How do I check if a certain SQL statement is being run?
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.