Dear Team,
I am trying to configure auditing in Azure SQL managed instance server as per below article,
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure
But facing an issue that ALTER SERVER AUDIT statement cannot be used inside a user transaction though, I have mentioned commit as False in the playbook tasks. I have tried executing same from SQL studio with same user access and able to configure it successfully. Can someone please help how to fix this issue or any other alternate approach ?
I am using community.general.odbc module
Thanks & Regards,
Gowtham SM