How to Create Server Audit Specifications in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to create Server Audit Specifications in SQL Server using SQL Server Management studio as well as using T-SQL Script. It shows all the events to capture using Audit, how to create Audit, how to create Audit specifications using existing Audit. How to capture events such as creating and dropping databases in SQL Server, how to find out who created and dropped the databases and how to capture login failure on SQL Server instance etc.


Create Server Audit Specifications in SQL Server

3 comments:

  1. Thank you so much for the video tutorial.

    ReplyDelete
  2. Thank you very much, I learn a lot from your videos

    ReplyDelete
  3. Hi, thank you so much for the excellent tutorial, I need a help, could you please send me the structure of the 'PermissionAudit' table, I am getting error, please requesting for a favorable reply at the earliest, as I tried my level best to figure out but I am unable to do so. Thank you

    ReplyDelete