SQL Server Performance Forum – Threads Archive

Locks on a table

plz do tell me ….
how to check no of locks active on a table/database
suing a query in SQL Server.
Thanks

Hi,
sp_lock will gives you lock information refer BOL for more . Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

also see
http://www.sommarskog.se/sqlutil/aba_lockinfo.html Roji. P. Thomas
http://toponewithties.blogspot.com

]]>