You can you the old master.dbo.sysprocesses or the newer dmv
sys.dm_exec_sessions
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]