http://www.sqlservercentral.com/blogs/kyle-neier/2012/03/29/error-18456-a-little-more-friendly-in-2012/ Printed 2016/09/26 10:17AM
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