Just Learned - Finding out Locked tables in SQL Server 2005

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

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 · · · ·

Previous: SCOPE_IDENTITY() sometimes returns incorrect value
Next: SQL BI - Powerview reports could be exported to PowerPoint (PPT)!

Conficker

232 · 1% · 193

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	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 · 33% · 10587

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