October 12, 2011 at 3:09 pm
Hello fellow guru's,
I need to know if there's a tool or script out there that allows me to see where changes are made in my database when a record is changed.
For example, a user enters a new customer. What tables/columns are updated? I need a tool/script to show me that ...
October 12, 2011 at 5:23 pm
Look up DML triggers .. in Books On LIne. Pay particular attention to the INSERTED and DELETED tables that triggers can generate
October 12, 2011 at 10:09 pm
Use Change Data Capture(CDC) capture the changes made in table.
Refer to the following link for details:
October 12, 2011 at 11:12 pm
To me, Nothing is free. Do only for required tables...
October 13, 2011 at 10:43 am
CDC is great, thank you for the advice.
I do have a question that my research has not yielded a valid response.
CDC captures each table that a change occurs. A new record or deletion of a record inserts a value into the _CT table created by CDC. What I need is a way to search ALL of the CDC tables for a change. Insert a record, run a script for the all the tables that changed, then delete a record, run a script to see what tables have changed, repeat and rinse...
October 13, 2011 at 10:45 am
sqlzealot-81 (10/12/2011)
To me, Nothing is free. Do only for required tables...
The problem here is, I don't know the tables. I need to do a series of actions in the application and capture all the tables that are changed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply