Find blocking processes using recursion in SQL Server 2005

(Tim Chapman) Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This causes the second process to wait until the first process is done so it can acquire the records; this can cause

Read More - Register for Free Membership