SQLUSA

Microsoft SQL Server 2005 Best Practices

How to find blocked processes?

 

Run the following script in the application database:

use AdventureWorks
select * from sys.sysprocesses where blocked != 0


 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page