Query Analyzer Only - Who's doing what

[saw15]

With only access to the query analyzer in SQL Server 2000, is there any query that I can perform to determine who is doing what, and where the server is in a process? Appears that the server is hung and am looking for a way to determine if this is the case etc.

Any help is appreciated. Again .. I have only got access to the DB via query analyzer.

Thanks.

 

[Mierk]

sp_who and sp_who2 are pretty handy

 

[saw15]

Thanks.. just what I was looking for.

Quick question..

Both of the items that I was looking for indicate a status of runnable. Does this mean that they are running? Or do I need to start them?

 

[Mierk]

try using

sp_who2 'active'

to see what is actively running on the server.