bodhilove
SSCarpal Tunnel
Points: 4035
More actions
June 14, 2009 at 7:54 pm
#206261
will the default trace audit a login change that any user does (e.g change password). If not what is the best way to do it?
RBarryYoung
SSC Guru
Points: 143329
June 14, 2009 at 11:39 pm
#1009477
A trace can definitely capture it, though I am not sure if the default trace captures this information, "by default".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"] Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
ps.
One Orange Chip
Points: 29255
June 15, 2009 at 5:59 am
#1009571
I checked it's not captured by the default trace.
This URL provides list of all security audits that can be performed.
http://msdn.microsoft.com/en-us/library/ms191148(SQL.90).aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply