InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 03:27:53 GMT20http://www.sqlservercentral.com/Forums/Topic813548-146-1.aspxTry this:SELECT r.*,t.text FROM sys.dm_exec_requests r cross apply sys.dm_exec_sql_text(r.sql_handle) tWHERE r.status IN (N'Suspended',N'Running',N'Runnable',N'Pending')The text column is the code of the procedure/batch that is currently running in SQL ServerIf all your SPs finish every quickly, the query may not be able to catch anything.You can try the following in a separate window then run the above query, you will catch itselect * from master.dbo.spt_valuesWAITFOR DELAY N'00:30:00'Wed, 04 Nov 2009 07:35:06 GMTpeterhehttp://www.sqlservercentral.com/Forums/Topic813548-146-1.aspxnot sure what you mean...inside a TSQL code block, you could use [code]print object_name(@@PROCID) [/code]or do you mean show me all the sql statements that are currently running on the server, like from one of the DMV's?[code]SELECT DEST.TEXT FROM sys.[dm_exec_connections] SDEC CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST --WHERE SDEC.[most_recent_session_id] = @spid [/code]Wed, 04 Nov 2009 07:24:38 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic813548-146-1.aspxIs there anyway i can find out currently running stored procedure name ?Wed, 04 Nov 2009 05:49:48 GMTsreddyv26