Viewing post 1 (of 1 total)
Select spid,hostname,program_name,nt_username,loginame,cmd, t.text from sys.sysprocesses
CROSS APPLY( select text from sys.dm_exec_sql_text(sql_handle))t
This query will list all the queries currently executing along with SPID's.
September 15, 2010 at 8:54 am
#1221400