 | Company: | Link Technologies | | Case No: | L12385 | | Logged By: | Sanjay (Link Technologies) on 20 Jul 2011 11:49PM | | 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:49 PM [4658 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: L12385 in the subject line of all emails regarding this issue.
Document size: 0.4 KB
For call complaints, please contact the Managing Director of the company using this form. |