/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

1 vote262 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote246 views1 answer
Lister les index d'une table oracle
SQL
0 vote293 views3 answers
How to verify sequence result in oracle SQL
SQL
13 votes278 views3 answers
Insert mysql ifile nto database
SQL
0 vote255 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
10 votes241 views2 answers
Mysql select timestamp group by day
SQL
0 vote282 views1 answer
Wordpress database query change url
SQL
0 vote291 views2 answers
Amazon linux postgresql client
SQL
6 votes247 views1 answer
Rank function in oracle with example
SQL
0 vote280 views1 answer
Watch mysql command line
SQL