Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

SP_WHO Filtering - SQL Server

if object_id('tempdb..#spwho') is not null drop table #spwho

create table #spwho (
     spid       int not null
    ,ecid       int not null
    ,status     varchar(10) not null
    ,loginame   nvarchar(300) not null
    ,hostname   nvarchar(300) not null
    ,blk        int not null
    ,dbname     nvarchar(300) null
    ,cmd        nvarchar(1000) not null
    ,request_id int not null
)

insert into #spwho
exec sp_who

select * 
from #spwho
where blk <> 0