dannibrook
SSC Veteran
Points: 212
More actions
March 24, 2002 at 3:05 am
#78277
how can auditing of logons to SQL server be done. I want to be able to exclude particular users from the audit.
Andy Warren
SSC Guru
Points: 119902
March 24, 2002 at 7:33 am
#425984
You can profile to capture logins and profile does have the ability to filter as it executes. If the profile is complex it's usually better to simplify it and then load the data into a table and filter from there.
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Steve Jones - SSC Editor
Points: 736212
March 24, 2002 at 4:27 pm
#425986
There is also an event that fires (1864?) and you can capture this as an alert.
Steve Jones
steve@dkranch.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply