Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Finding out Locked tables in SQL Server 2005

Mar 6 2012 12:00AM by Conficker   

to find locked tables in SQL Server 2005 ,

sp_lock

and use Object_Name() to find out name of the table,

SELECT Object_Name(ObjectID)

Read More..   [32134 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Conficker
230 · 1% · 195
5
 
3
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

1  Comments  

  • This is a valid method for SQL 2000, however, sp_lock has been marked for deprecation since SQL 2005. The alternate is to use the DMV - sys.dmtran_locks

    commented on Mar 6 2012 5:32AM
    Nakul Vachhrajani
    4 · 36% · 11635

Your Comment


Sign Up or Login to post a comment.

"Finding out Locked tables in SQL Server 2005" rated 5 out of 5 by 5 readers
Finding out Locked tables in SQL Server 2005 , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]