How to see current executing query

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