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
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757