Answers for "how to check which sp is running in sql server"

SQL
0

how to check which sp is running in sql server

SELECT
  object_name(st.objectid) as ProcName
FROM
  sys.dm_exec_connections as qs 
CROSS APPLY sys.dm_exec_sql_text(qs.most_recent_sql_handle) st 
WHERE
  object_name(st.objectid) is not null
Posted by: Guest on November-25-2020

Code answers related to "how to check which sp is running in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language