September 16, 2022 at 6:20 am
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
September 17, 2022 at 7:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 29, 2022 at 6:25 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply