Company: Link Technologies
Case No: L12386
Logged By: Sanjay (Link Technologies) on 20 Jul 2011 11:50PM
Priority: Not Applicable
Product: Other
Group: To be assigned
Time Taken: 0.00
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Wednesday, 20 July 2011 11:50 PM [4636 days since logged date]
Status: Closed
Subject: SQL Server Security and Administration Tasks
Summary:    Here is a simple query that will list out users on SQL server and their last ctivity. Run this on the master database. you can use this as a template to extract current user and process information:

select p.loginame, max(p.last_batch)
from sysprocesses p inner join sysusers u on p.uid = u.uid
group by p.loginame
order by 2 desc
Audit Notes:
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12386 in the subject line of all emails regarding this issue.

Document size: 0.3 KB
For call complaints, please contact the Managing Director of the company using this form