February 25, 2009 at 5:00 am
Hi everyone, i urgently need to find a way to monitor or see activity of a particular login.
This specific login was disabled by the dba but somehow it shows in the login statistic report SSMS that the login is being used somehow, of this this is a concern to us...
any help or advice appreciated.
Thanks
February 25, 2009 at 6:09 am
SELECT * FROM sys.dm_exec_sessions WHERE original_login_name LIKE '%usertest%'
this seems to be ok, anyone got anything else to add:)
February 25, 2009 at 6:39 am
You could create a trace that filters on that login name.
Is this a Windows login or a SQL Server login? If it is a Windows Login you need to check to make sure that it is not getting access via a Windows Group.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 25, 2009 at 6:52 am
its a sql server login...
February 26, 2009 at 8:57 pm
Define LOGON TRIGGER in your 2005 or 2008 server:
- you can copy logon data into audit table
- or you can roll back logon sessions for specific login names
Tamas Csesztregi
chemist
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply