Home Forums SQL Server 2008 Security (SS2K8) SQL Server Audit Specifications and SQL Trace comparision RE: SQL Server Audit Specifications and SQL Trace comparision

  • jasona.work (2/24/2016)


    DATABASE_PERMISSION_CHANGE_GROUP - Replaces Trace Event 102Audit Database Scope GDR Event

    SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP - Replaces Trace Event 103Audit Schema Object GDR Event

    SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 104Audit Addlogin Event

    SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 106Audit Login Change Property Event

    SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 105Audit Login GDR Event

    I recently started looking at replacing the Trace I run on my servers with Audits, this page: https://msdn.microsoft.com/en-us/library/cc280663(v=sql.120).aspx is the best cross-reference you'll find. Just CTRL+F, key in the Trace event you're interested in, and get the equivalent Audit Specification.

    Perfect , thanks for the reply.