Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-07 : 04:06:07
|
I have a bunch of scripts and the script (each script has many DML lines) contains insert\update\delete activity for many tables i want to validate changed\deleted information from a table so am looking for any good approach.This is only for validation and its only for test env.I've made some approach1)creating triggers for all tables inside trigger log table will record changed activity ,table name and time2)we Can create SQL CDC to track the changes.apart from this any other approach |
|
|
|
|