| Script to Check Blocking |
|
|
|
| SQL Server - Articles | ||||||||
| Written by Sarabpreet Singh | ||||||||
|
This query will show you all user processes in sql server (all versions) which are blocked.
select loginame,spid,* from master..sysprocesses where blocked<>0 order by waittime desc
Only registered users can write comments!
Powered by !JoomlaComment 3.26
3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."
|




