The code from the article does not copy/paste correctly, so I am posting it here. I have noticed that if you paste it into Word or Open Office it will display correctly.

CREATE TABLE #sp_who2

(

SPID INT,

Status VARCHAR(1000) NULL,

Login SYSNAME NULL,

HostName SYSNAME NULL,

BlkBy SYSNAME NULL,

DBName SYSNAME NULL,

Command VARCHAR(1000) NULL,

CPUTime INT NULL,

DiskIO INT NULL,

LastBatch VARCHAR(1000) NULL,

ProgramName VARCHAR(1000) NULL,

SPID2 INT

)

Create Table #SqlStatement

(spid int,

statement varchar(8000))

create table #temp (x varchar(100), y int, s varchar(1000), id int

identity (1,1))

INSERT #sp_who2 EXEC sp_who2

Declare @spid varchar(10)

Declare @Statement varchar(8000)

declare @sql varchar(1000)

DECLARE SpidCursor Cursor

FOR Select spid from #sp_who2

OPEN SpidCursor

FETCH NEXT FROM SpidCursor

INTO @spid

WHILE @@FETCH_STATUS = 0

BEGIN

SET @sql = 'dbcc inputbuffer (' + @spid + ')'

insert #temp

exec (@sql)

Insert Into #SqlStatement

Select @spid, s From #Temp where id = (Select max(id) from #Temp)

FETCH NEXT FROM SpidCursor

INTO @spid

END

Close SpidCursor

Deallocate SpidCursor

Select B.Statement, A.* from #sp_who2 A Left JOIN

#SqlStatement B ON A.spid = B.spid

Drop Table #Temp

Drop Table #SqlStatement

Drop Table #sp_who2