Blocking in SQL Server

SELECT * FROM dbo.sysprocessesWHERE blocked <> 0;

SELECT * FROM dbo.sysprocesses WHERE spid IN (SELECT blocked FROM dbo.sysprocesses where blocked <> 0);

No comments:

Post a Comment

Popular Posts