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