Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

View all table Change Data Capture Expand / Collapse
Author
Message
Posted Wednesday, December 04, 2013 9:26 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 2:29 AM
Points: 235, Visits: 343
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
Post #1519857
Posted Thursday, December 05, 2013 5:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 9:40 AM
Points: 41, Visits: 161
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
Post #1519985
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse