Olaf,
Thanks for the prompt response. But i still fail to understand the below
Audit enhancements from SQL_Server_2016_Mission_Critical_Performance_White_Paper.pdf
SQL Server 2016 can now audit the success or failure of operations. When a user attempts to perform an
operation, the user must first have permission to perform that operation. Prior versions of SQL Server
could track and audit whether a permissions check succeeded or failed. But even if a user has permission,
it is still possible that the desired operation might fail due to referential integrity rules or another
constraint. SQL Server 2016 audits transaction events, both explicit as well as implicit, so that the success
or failure of the operation (in addition to the permission check) can be determined from the audit log
Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.
