This error can occur when the file is open (in Excel).

For error 18456, the value of "State" describes the reasons why the login failed. A state of 16 indicates that the default database for the login is not available.

Paul Berzukov posted

totally agree with Don Peterson's position on the matter but please note neither original poster nor anybody else in this thread is suggesting the creation of a...

There is no deadlock wait period, which is why you cannot find any information. When a deadlock is detected, the transaction that needs the least amount of resources to...

Don Peterson has written an article on why you should not use the type of design that you are proposing: "Lookup Table Madness" at http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/

If these servers are dedicate to running SQL Server, you should be seeing very little paging.

A few questions:

Have the SQL Server service accounts been granted the "lock pages in memory"...

Does the errorlog file have a large number of messages for backup operations ? These messages can be suppressed with trace flag 3226 See http://msdn.microsoft.com/en-us/library/ms188396.aspx

Do you mean the size of the database log file ( ldf extention) or the size of...

A look in the application log of the server shows that the DB in question was starting up and doing a checkdb about once a minute. Someone had it set...

With the SQL Server Configuration Manager open, expand "SQL Native Client Configuration", right click the 'Aliases' in the tree, and choose 'New Alias'. There are 4 items...

There are multiple parts to the solution:

1. for each columns, convert numeric values to a numeric data type and non-numerics to null

2. sum the three columns after...

You do not resolve the SQL Server instance name with DNS but instead use the SQL Server utilities...

There is a very long set of posts titled "Just the date, please"

http://www.sqlservercentral.com/Forums/Topic379596-8-2.aspx

The below method is 10 times faster than converting to character and then truncating the time portion:

CAST(convert(int,...

Not using SQL directly:

The WMI ODBC Adapter is not available in Windows Server 2003. When you upgrade to Windows Server 2003 from Windows 2000 Server, the WMI ODBC Adapter is...

Linchi Shea has a six part blog titled "Performance Impact: file fragmentation and SAN" that will cover may of your questions at http://sqlblog.com/blogs/linchi_shea/archive/2008/12/07/performance-impact-file-fragmentation-and-san.aspx

Database files will fragment whenever the file automatically...