How to identify blocking in SQL Server 2005 and 2008

(Nitansh Agarwal) In our SQL Server environment, we have frequent locking and blocking across a few different versions of SQL Server. How can I find blocking and blocked SPID’s in SQL Server 2005 and later versions? Is there only one way to find out which spids are blocking? Are there any commands

Read More - Register for Free Membership