How do I find what queries were executing in a SQL memory dump?

NOTE:  This post has been updated in a new post due to an issue found with the steps in this post.  The procedure is the same, but the steps here may only work with 32 bit dumps.  Please read the post located at the address below: http://blogs.msdn.com/b/askjay/archive/2011/02/18/finding-which-queries-were-executing-from-a-sql-memory-dump-revisited.aspx —————————————————————————————————- In this post, we’ll see how to…

8

Catching who dropped SQL Server logins

I recently had a situation where SQL server logins were getting deleted from the system and nobody could figure out why or by whom.   So in this post, we present a few ways to catch this. First, if you are using SQL Server 2008, the easiest method is to capture this via the new Auditing…

1