Understanding auditing

In this section I'd like to talk about some of the changes to auditing in SQL Server 2012. …I have a little sample code for you. I'll copy and paste over just the top part for …now, paste that into Management Studio. …We have some new options on the ON_FAILURE area here. …The default is still ON_FAILURE to continue. …So in other words if for some reason the machine is not able to audit the particular action, …the machine will continue running, the SQL Server will continue operating as normal, …just nothing will be audited.…

In previous versions of SQL Server, once it failed to audit once it would stop trying. …That has changed in 2012. …Even if it fails once, when it's time to audit again it will try again, and if it fails then …it will try again, over and over. …If it ever becomes successful again the auditing will pick up from there. …We also have the option ON_FAILURE to shut down the server. That hasn't changed since …previous versions. That's obviously a very aggressive way to go, but it is the most secure.…