It works fine for SQL 2005 if you add an extra column to the create statement of #sp_who2

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

, RequestId INT -- Extra column for SQL2005

)