在书上看到这样一个例子,可以把sp_who的输出内容写到一个表里,对这个问题应该有点帮助.
CREATE TABLE MyTable
(
spid smallint,
ecid smallint,
status nchar (30),
loginame nchar (128),
hostname nchar (128),
blkchar (5),
dbname nchar (128),
cmdnchar (16)
)
GO
INSERT MyTable
(
spid,
ecid,
status,
loginame,
hostname,
blk,
dbname,
cmd
)
EXEC sp_who |