SQL Server Performance Forum – Threads Archive
Locking tableswhat is the best command to find out who lock a specific table?
You can combine them.
I got it, but how do I know the table is locked ??
when u run sp_lock it returns objid which is the object id requesting lock and then run below query select * from sysobjects where id=objid
Regard Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
Fyi. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.