Viewing post 1 (of 1 total)
I added this bit to the select to get the user accout:
UserLogin = (
select
convert(sysname, rtrim(loginame))
from
master.dbo.sysprocesses
where
spid = a.session_id
),
Great script. thanks!
March 15, 2012 at 3:28 pm
#1460216