Link Details

Previous | Next

Surprise Me!
Link 78578 thumbnail
User 225256 avatar

By mswatcher
via weblogs.sqlteam.com
Published: May 01 2008 / 23:10

SQL Server 2005: Get full information about transaction locks
Sometimes we wish to know what locks are being held by the transaction. Also it would be great to know what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc...
Vote up
Vote down
  • 6
  • 0
  • 1191
  • 143
SaveShareSend Tags: ,

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (6)



Voters Against This Link (0)