Does the CDC feature not meet your needs? The best way to do this is at the database level since it will record all the changes people might make directly on the database, bypassing the application. You can supplement this using extra code at the application level, such as passing in the user name to every query, since the database probably doesn't know what user is making the change. The solution usually involves a lot of database triggers and extra columns added to track the user, timestamp, and action. ApexSQL is one company offering an audit tool that helps create these triggers. I remember those triggers being somewhat generic, although it will give you another example to look at. Most of the solutions involving triggers follow a similar design pattern. None of the commercial products would solve the issue of logging which Web site user made the change, which would require custom code both at the application level and the database level. This assumes you are using the same database connection string for every Web site user and that you care about who makes the database changes.
-Mike Chabot On Thu, Mar 28, 2013 at 2:33 PM, Asim Manzur <[email protected]> wrote: > > 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:355193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
