How to query SQL Server User processes

select *
   from sys.sysprocesses a
cross apply sys.dm_exec_sql_text (a.sql_handle) b

This site uses Akismet to reduce spam. Learn how your comment data is processed.