17 May 2010

sp_who filtrata

set nocount on

drop table #boso

create table #boso
(
	spid nvarchar(max), 
	ecid nvarchar(max), 
	status nvarchar(max), 
	loginame nvarchar(max), 
	hostname nvarchar(max), 
	blk nvarchar(max), 
	dbname nvarchar(max), 
	cmd nvarchar(max), 
	request_id nvarchar(max)
)

insert #boso
exec sp_who


select * 
from #boso
where dbname = 'ITPORTAL_FALCONE'
order by status