This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
About 6 months ago we decided to look at what SQL Server engine error messages are most commonly generating support cases to Microsoft. The end goal was to update the documentation for those error messages to allow our customers to find answers for themselves before they have to call Microsoft for technical assistance.
The task, as we suspected from previous experience, was not easy because we had to mine cases for error numbers and a relatively small number of support cases get reported with error messages when they are opened. Please report full error messages when you open support cases with Microsoft - it would help us get you answers faster. Still, we were able to find the trends even from the small percentages because were looking for the top 20 or so most common errors, based on case count, and we needed relative information - which error is reported more than another.
As a result, over the past 6 months or so we have been updating and creating SQL Server engine errors (MSSQLSERVER_XXXX) or for some of them validated the content was relevant. Many of these errors did not have any documentation at all and some were updated with more detailed instructions and insights. With over 14,000 error messages in SQL Server engine alone, the realistic approach is to focus on documenting the common ones.
Here is the list of errors that we created or updated to help with your troubleshooting efforts and, we hope, complete resolution:
Finally, please provide feedback on these errors or any others for that matter. You can either put your comments here under this blog post or the best option is provide feedback under each error by using the Feedback button in each article: