Written by:R Teachout
12/12/2007 6:10 PM

Use Master
Select Spid 'Session ID', Nt_UserName 'User Name',HostName 'Machine Name', SysProcesses.dbid 'DB id', sysdatabases.name 'Database Name', LogiName 'Logon Name', Program_Name Application, Convert(VarChar(30), login_Time, 100) 'Time Stamp'
From SysProcesses 
INNER join sysdatabases on SysProcesses.dbid=sysdatabases.dbid
where Nt_UserName Not In ('sa', 'System') And LogiName <> 'sa' 
order by name

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel