how to insert sp_who value into a table?

[kmsam2]

any idea how to insert sp_who value into a table?

Sam.

 

[vongrunt]

Yup... if table structure matches response:

create table #blah
(	spid smallint,
	ecid smallint,
	status nchar(30),
	loginame nchar(128),
	hostname nchar(128),
	blk char(5),
	dbname nchar(128),
	cmd nchar(16)
)

[b]insert into #blah exec sp_who[/b]
select * from #blah
drop table #blah