Monday 30 May 2011

blocking database wise

select * from sys.sysprocesses where dbid=2 and

select * from sys.sysprocesses where dbid=5 and blocked>0
sp_helpdb

No comments:

Post a Comment