You may be aware using SP_WHO or SP_WHO2 statements you can get information about a session id and statement that is running since good olden days of SQL Server. Within SQL 2005 version you can take help of TSQL: SELECT session_id, text FROM sys.dm_exec_requests s1 CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2 Similarly you can look at ...