SQL Server 2012 Auditing Question

  • I am currently trying to set up SQL Server audit specifications, but they are not showing with the following query: select distinct(eventid) from sys.fn_trace_geteventinfo(1)

    When I run the query it only shows defaults. However prior to installing KB2958429 (SP 2), the audit specifications manually selected showed up with the query. So, I installed KB3045321 (a later version of SP2), which works on other servers. I am at a loss right now. The audit specification actions I have selected are below. Any advice would be greatly appreciated.

    database_role_member_change_group

    database_principle_change_group

    server_principle_change_group

    audit_change_group

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • This was removed by the editor as SPAM

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply