Comments (6)

  1. Emil Glownia says:

    Nice blog post. Goes really into details.

    Here's another post that is more on high level explanation

  2. TokyoDrifter says:

    This is one of the most helpful connectivity error-related articles I've found on the net. Thanks!

  3. Daniel Adeniji says:

    Thanks for posting.  This is very useful information.  Thanks for sharing and allowing all to benefit from your hard-work.

  4. Lifesaver! Loads of other blogs listing the state codes, but almost all stop at 18. Not much use when I was searching for state 38! Thanks for posting.

  5. Shanky_621 says:

    excellent blog..thank you

  6. Mike H says:

    Why do you say "(Not DBCC TRACEON)"

    Are there caveats to using this method? I don't want to have to restart the SQL server!