/SQL/How to check which sp is running in sql server

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

Source: stackoverflow.com

Similar codes

5 votes207 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote215 views1 answer
Drop unique
SQL
0 vote233 views1 answer
Insert ip address in mysql
SQL
0 vote237 views1 answer
Oracle dynamic select into
SQL
0 vote228 views1 answer
Shortcut run sql pgadmin
SQL
0 vote230 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
2 votes231 views2 answers
Spring import sql
SQL
6 votes206 views2 answers
WHERE value IS sql
SQL
23 votes206 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote215 views1 answer
Mysql date minus 1 day
SQL