Listing 3: Code to Display the SQL Statements Currently Executing

DECLARE @MV_PROCESS CHAR(40), @MV_COMMAND2 CHAR(254)
DECLARE CUR_TABLE_LIST CURSOR FOR 
  SELECT P.SPID 
	FROM MASTER..SYSPROCESSES P 
	WHERE P.CMD <> 'AWAITING COMMAND' AND P.SUID <> 1 AND P.SPID <> @@SPID
OPEN CUR_TABLE_LIST
FETCH NEXT FROM CUR_TABLE_LIST INTO @MV_PROCESS
WHILE (@@FETCH_STATUS <> -1)
     BEGIN
	IF (@@FETCH_STATUS <> -2)
	BEGIN
		SELECT @MV_COMMAND2 = "DBCC INPUTBUFFER ( " + @MV_PROCESS + ")"
		EXEC (@MV_COMMAND2)
	END
     	FETCH NEXT FROM CUR_TABLE_LIST INTO @MV_PROCESS
     END
DEALLOCATE CUR_TABLE_LIST