Question Locked

how to find locks by table in SQL

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to find a way to find out if there are any locks on a given table. Does anyone one know of any way to find this info out?

Running SQL 2005 on Windows.

3 replies

by shellbot

chose your database, then

exec sp_lock

will show you any locks in the database.
However, if trying to find ones that are locking and releasing before it can catch them, may have to go in and use Profiler

This discussion is closed to new replies.