SELECT * FROM dbo.sysprocessesWHERE blocked <> 0;
SELECT * FROM dbo.sysprocesses WHERE spid IN (SELECT blocked FROM dbo.sysprocesses where blocked <> 0);
DBAHUB was created as a community service, with the goal to share SQL Server & Azure knowledge through articles. Hope it will help others to improve their knowledge.
No comments:
Post a Comment