to capture the results form a stored procedure, the table must exist, with all the columns defined;

then you can do something like this:

IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'WHO_DATA') AND xtype in (N'U'))

CREATE TABLE WHO_DATA (

[WHORESULTSID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

[SPID] CHAR (5) NULL,

[INSERTDT] DATETIME NULL DEFAULT(GETDATE()),

[STATUS] VARCHAR(30) NULL,

[LOGIN] VARCHAR(30) NULL,

[HOSTNAME] VARCHAR(30) NULL,

[BLKBY] VARCHAR(30) NULL,

[DBNAME] VARCHAR(30) NULL,

[COMMAND] VARCHAR(30) NULL,

[CPUTIME] INT NULL,

[DISKIO] INT NULL,

[LASTBATCH] VARCHAR(30) NULL,

[PROGRAMNAME] VARCHAR(200) NULL,

[SPIDINT] INT NULL,

[REQUESTID] INT NULL

)

--table exists, insert some data

INSERT INTO WHO_DATA(SPID,Status,Login,HostName,BlkBy,DBName,Command,CPUTime,DiskIO,LastBatch,ProgramName,SPIDINT,REQUESTID)

EXEC sp_who2

there's a bit of a work around you can try by using openrowset:, it tends to be a LOT slower, but it works:

--database name required

SELECT *

INTO #tmp

FROM OPENROWSET( 'SQLNCLI',

'Server=(local);Trusted_Connection=yes;',

'SET FMTONLY OFF; SET NOCOUNT ON; exec master.sys.sp_who'

)