| Groups | Blog | Home |
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Views Posted by Bill Byrnes at 1/21/2007 8:38:46 AM I am new to SQLServer 2005 but not to relational databases. I am puzzled by
the behavior of views. I can use the view in Visual Studio or open it in
SQLServer Management studio and the virtual table displays correctly except
for sorting (ORDER BY in the SQL statements). Joins and filters all w...more >>
SQL SERVER 2000: obtain user list Posted by diaboliko80 NO[at]SPAM gmail.com at 1/18/2007 5:55:34 AM Hi,
I would like extract in a document (.doc, .txt, .cvs, .xml or also) the
complete list of all user that logins to my SqlServer 2000.... that is
I need to know for each user to which databases accedes.
For example, the user TOM WHITE accedes to the database [SCHOOL],
[NEWS] and [JOB] with r...more >>
SQL 2005 Log Shipping Posted by hobbzilla at 1/17/2007 9:51:15 PM So, I have a primary database performing log shipping to a secondary
database. The logs are being backed up shipped and restored onto the
secondary.. NOW WHAT?
Trying to test the effectiveness of the solution, but have not found a
single article on how to promote or activate, etc the secondary...more >>
Rather urgent: Cannot open user default database. Login failed. Posted by JimCinLA at 1/16/2007 10:48:43 AM On an ASP.Net 2.0 appliaction, I use ASPNETDB.mdf in the project's
App_Data subdirectory for forms authentication. This works fine inside
Visual Studio 2005.
When I deploy the application to an IIS server on the same computer,
I cannot open ASPNETDB.mdf. I get the usual message:
...more >>
SA Password Change Posted by whitehsm NO[at]SPAM gmail.com at 1/15/2007 3:50:37 PM Our DBA has just left our company and I am covering for the meantime. I
have some very basic SQL server skills and have been asked to change
the sa password on all SQL installations/instances (we have a SQL
Cluster environment as well as stand alone SQL installations).
What is the best way to ...more >>
What is Causing a Sudden Increase in User Connections? Posted by rob at 1/15/2007 12:14:04 PM A few times a day we get a dramatic increase in the number of user
connections on our database (sometimes 4 to 5 times as many according
to perfmon). Here is some additional information...
- from the time the number of connections starts to increase to the
time it drops back down to a "normal...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |