Post reply

Extended events

  • December 30, 2019 at 4:31 am

    #3711083

    Q1. Lets say I want to audit DDL , DML, DCL, DQL statements

    Can we use extended events to create an auditing solution in SQL Server for such a requirement ?

    Or are there better/efficient not so resource intensive alternatives ?

    Thanks

    Q2. What is best way to audit any account which connects to a sql server database ?

    Thanks

     

     

    • This topic was modified 4 years, 3 months ago by  mtz676.

  • December 30, 2019 at 10:57 am

    #3711130

    Q1 You can use Extended Events, but there's a ready-baked SQL Audit feature that it would be easier for you to use.

    Q2 Are you talking about a particular database, or any database?  What do you mean by "connects to"?  Does it include three- or four-part object name references invoked from the context of other databases?  Try experimenting with the Successful Login action type, and database-level actions that you filter so that you only capture actions on the database you're interested in.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply