select *
from sys.dm_exec_connections con,
sys.sysprocesses procs,
sys.dm_exec_sessions sess
where con.session_id = procs.spid
and sess.session_id = procs.spid
and procs.spid > 50
select *
from sys.dm_exec_connections con,
sys.sysprocesses procs,
sys.dm_exec_sessions sess
where con.session_id = procs.spid
and sess.session_id = procs.spid
and procs.spid > 50
There are no replies to this post.