SQL Server Error ReferenceSQL Server error messages are not always very helpful. Errors appearing in the error log and windows event log may not necessarily be related to SQL Server but should still be investigated. See this article to find out why.
I regularly encounter error messages that subsequently lead me to spend hours tracking down the cause. The answer may be found in forums, Books Online, technet, Microsoft support, or just plain old trial and error.
To save you from going through the same pain I have written articles on common errors and some not-so-common, explained the likely cause, and given suggestions on how to troubleshoot them.
Please subscribe to my RSS feed for regular updates.
This article describes a methodical approach to diagnosing the cause of this error...
I highly recommend SQL CoPilotI can investigate performance issues, get a big picture of the state of my servers, find out what is causing all those deadlocks, and more.
SQL CoPilot answers all my questions, and is a FREE download.