Using SQL Server Management Studio, how can check or see who is running a certain SQL statement?
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
The Extended Events event is