There are various way in sql server to see current executing query .. Using DMV select * from sys . sysprocesses where status = 'Running' select * from sys.dm_exec_Requests where status=' Running select * from sys.dm_exec_sessions where status=' Running ' Using DBCC a. DBCC opentran b. DBCC inputbuffer ( SP_ID ) SSMS GUI using Activity Monitor. DBCC opentran DBCC inputbuffer ( SP_ID ) CREATE TABLE T1 ( Col1 int , Col2 char ( 3 )); GO BEGIN TRAN INSERT INTO T1 VALUES ( 101 , 'abc' ); GO DBCC OPENTRAN ; ROLLBACK TRAN ; GO DROP TABLE T1 ; GO
Connecting, Sharing and Discovering