http://sqlblog.com/blogs/denis_gobo/archive/tags/Trace/default.aspxTags: TraceenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/denis_gobo/archive/2007/06/03/1395.aspxSun, 03 Jun 2007 19:33:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1395Denis Gobo1http://sqlblog.com/blogs/denis_gobo/comments/1395.aspxhttp://sqlblog.com/blogs/denis_gobo/commentrss.aspx?PostID=1395http://sqlblog.com/blogs/denis_gobo/rsscomments.aspx?PostID=1395Paul Randal writes: <BLOCKQUOTE>"Kimberly mentioned that SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder, which I'd never heard of. It's an internal trace that has the last 5MB of various trace events and it's dumped to a file when SQL Server crashes. This can be really useful if you're troubleshooting an issue that causing SQL Server to crash or someone or something is telling SQL Server to shutdown and its unclear who or what is doing it." </BLOCKQUOTE>Read here how to turn it on: <A href="http://blogs.msdn.com/sqlserverstorageengine/archive/2007/06/03/sql-server-s-black-box.aspx">http://blogs.msdn.com/sqlserverstorageengine/archive/2007/06/03/sql-server-s-black-box.aspx</A><img src="http://sqlblog.com/aggbug.aspx?PostID=1395" width="1" height="1">InternalsSQL ServerTrace