Post reply

View all table Change Data Capture

  • December 4, 2013 at 9:26 pm

    #302103

    Hi All Experts,

    I have query regarding CDC and Auditing. I have enables both in the server , however I like to see all changes that has been made against a given database,right now I have to query the cdc table individually to see the changes made to those tables instead is there any query or other option to see all changes in database at a stretch.

    Requirements

    1) To see who made the changes at what time

    2) which all tables or data's were affected.

    3) Need a query or other option to see all the above said requirements

    Thanks & regards

    MJ

  • December 5, 2013 at 5:48 am

    #1671017

    Hi

    which version SQL server your using in your enviroment ,if you using the SQL server 2008 then you can enable the audit at database level as well as server level .

    Regard

    Vivek

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

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