how to find locks by table in SQL
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.
Software
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.
by dwjongbloed Accepted solution
by shellbot Accepted solution
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
by aks_osd Accepted solution
This discussion is closed to new replies.
Sort by Trending