Sunday, October 9, 2011

SQL Server : What is running right now?

SQL 2000
select * from master.dbo.sysprocesses where status <> 'sleeping'

SQL 2005+
select * from sys.sysprocesses where status <> 'sleeping'

Easier by far, use Adam Machanic's 'Who is Active'
PS : I've told you twice now!

No comments: