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.