Wednesday, March 28, 2012

Error 18456 a little more friendly in 2012

While preparing a demo for a presentation, I generated a 18456 error in the SQL instance by selecting a non-existent database in my connection string.

To my surprise, the SQL Errorlog now discloses the database that I was trying to connect to:


This seems to be improved for at least state 38 and state 40 of error 18456.

I no longer must create a trace to catpure the User Error Message to extract this information. Efficiency gained – now what to do with all that spare time?

About Kyle Neier
Husband of a magnificent woman, father of 5, SQL Server geek, IndyPASS Vice President and Food Guy, DBA automation zealot, amateur Powershell evangelist. Follow Me on Twitter

No comments: