B2 Audit Mode

Last Post 09 Aug 2010 11:43 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
jsh02nova
New Member
New Member

--
30 Jul 2010 04:15 AM
How does one get the Event number for the TraceId of Sql05's 43 Security Audit events?
• Audit Add DB User Event Class
• Audit Add Login to Server Role Event
• Audit Add Member to DB Role Event
• Audit Add Role Event
• Audit Addlogin Event
• Audit App Role Change Password Event
• Audit Backup/Restore Event
• Audit Broker Conversation
• Audit Broker Login
• Audit Change Audit Event
• Audit Change Database Owner
• Audit Database Management Event
• Audit Database Mirroring Login Event
• Audit Database Object Access Event
• Audit Database Object GDR Event
• Audit Database Object Management Event
• Audit Database Object Take Ownership Event
• Audit Database Operation Event
• Audit Database Prin***l Impersonation Event
• Audit Database Prin***l Management Event
• Audit Database Scope GDR Event
• Audit DBCC Event
• Audit Login Change Password Event
• Audit Login Change Property Event
• Audit Login
• Audit Login Failed Event
• Audit Login GDR Event
• Audit Logout
• Audit Object Derived Permission Event
• Audit Schema Object Access Event
• Audit Schema Object GDR Event
• Audit Schema Object Management Event
• Audit Schema Object Take Ownership Event
• Audit Server Alter Trace Event
• Audit Server Object GDR Event
• Audit Server Object Management Event
• Audit Server Object Take Ownership Event
• Audit Server Operation Event
• Audit Server Prin***l Impersonation Event
• Audit Server Prin***l Management Event
• Audit Server Scope GDR Event
• Audit Server Starts and Stops
• Audit Statement Permission Event
russellb
New Member
New Member

--
30 Jul 2010 05:42 AM
have a look at master.sys.trace_events
gunneyk
New Member
New Member

--
09 Aug 2010 11:43 AM
Also sp_trace_setevent in BooksOnLine has this as well.
You are not authorized to post a reply.

Acceptable Use Policy