Using SQL Server Management Studio, how can check or see who is running a certain SQL statement?


In SQL Server Management Studio you can use Activity Monitor. Right click on the root server item in Object Explorer or from the top panel. The Processes section contains info about the callers.


Depending on what your requirement is (i.e. you want to see a trace of all the times certain T-SQL was run) you may want to look at SQL Trace (Profiler will create a client-side trace and have a significant performance impact. Create a server-side trace by scripting out the trace in Profiler and running it directly on the server instead of keeping the Profiler trace running. If you need more info on this I can elaborate). Or if you're on SQL Server 2008 or higher then you should be using Extended Events.

The SQL Trace event class is SQL:StmtCompleted.

The Extended Events event is sql_statement_completed.


Use the stored procedure 'sp_who' or 'sp_who active'. This will show active processes


Use the built-in Profiler, you can find it under Tools->SQL Server Profiler.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy