You could use triggers it may have an impact on the database though. Another option would be to create stored procedures for doing all of your updates and deletes. You could then copy the original rows into another table with a flag saying a delete or update as well as who did it and when. After the data is copied, then you could actually run the update/delete.
Steve -----Original Message----- From: Asim Manzur [mailto:[email protected]] Sent: Thursday, March 28, 2013 2:34 PM To: cf-talk Subject: CDC in sql 2008 I need to keep track the changes in my all updates/deleted in sql. I was researching to find the solution and couldn't find anything useful. other than CDC in sql 2008. I don't want to handle this on application level .i.e. saving extra record in my audit table etc, I want to do it on database level. Really interested to know what others are doing ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
