SQL Server 2005 DMVs: Exposing the state of your server

(Adam Machanic) Ever want to find out which connections running T-SQL are blocking other connections? Sure, you could run sp_who or query the syslockinfo table, but what if you wanted more information to help debug the problem? For instance, how would you determine which T-SQL the blocking process w

Read More - Register for Free Membership