Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 query to get current processes

Author  Topic 

pithhelmet
Posting Yak Master

183 Posts

Posted - 2008-01-07 : 15:39:14
Hi everyone,

Is there a query that can be run to get the current processes that are being run on the sql server - like the current activity in EM??


thanks
tony

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-01-07 : 16:06:04
Select * from master..sysprocessess

or

Exec sp_who2

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

pithhelmet
Posting Yak Master

183 Posts

Posted - 2008-01-08 : 08:53:23
thank you!!

Go to Top of Page
   

- Advertisement -