http://www.sqlservercentral.com/blogs/kyle-neier/2012/03/29/error-18456-a-little-more-friendly-in-2012/

Printed 2014/11/26 05:33PM

Error 18456 a little more friendly in 2012

2012/03/29

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:

image

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
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.