sp_who_ex @onlyblocked= 1

dbcc traceon(3604) /* Return subsequent DBCC output to the client rather
                      than to the errorlog. */
go
SELECT * FROM master..SYSPROCESSES WHERE SPID= 324
go
-- Give 0 if SUID is not known.
-- DBCC PSS(SUID, SPID, 0)
DBCC PSS (6, 324, 0) /* Where suid is from above, and spid is the
                           unkillable SPID number. */
go
 
DBCC PSS (6, 324, 1) /* with default info, DES & TREE info*/
go
 
DBCC PSS (6, 324, 2) /* with locks info*/
print ''
exec master..xp_readerrorlog
go
 
DBCC PSS (6, 324, 3) /* with latch info*/
go

This page was last updated on May 01, 2006 04:28 PM.