SQL Server Performance Forum – Threads Archive
Locked ProcessesI was wondering if anyone had a script which notifies you when locksprocessid’s are blocked?
In the SQL Server 2000 world where system stored procedure sp_lock is used most often to find out the state of the current locks. Along these same lines, system stored procedure sp_who2 can return information about the spids, as well as any blocking conflicts. At the same time you have alerts in place in order to alert at the moment. KBAhttp://support.microsoft.com/kb/271509 fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.