Join Martin Guidry for an in-depth discussion in this video Understanding auditing, part of SQL Server 2012 New Features.
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.…
Author
Released
11/16/2012- Choosing an edition
- Finding and downloading SQL Server 2012
- Using FileTables to enhance FileStream
- Searching unstructured data semantically
- Searching text
- Exploring the Watch, Quick Watch, and Quick Info windows
- Creating user-defined server roles
- Understanding the changes to replication
- Exploring new types of indexes and new options on indexes
- Accommodating changes to database structure
Skill Level Intermediate
Duration
Views
Related Courses
-
Introduction
-
Welcome51s
-
-
1. Getting Started
-
2. Database Engine Improvements
-
3. Improvements to SQL Server Management Studio Debugging
-
4. Changes to the Scope of Objects
-
Understanding auditing4m 26s
-
5. High Availability from the Developer's Point of View
-
Exploring AlwaysOn5m 6s
-
-
6. Licensing
-
Choosing an edition4m 53s
-
-
7. Additional Changes
-
Conclusion
-
Goodbye2m 1s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Understanding auditing