Ati folosit vreodata vreun tool pentru urmarirea modificarilor pe anumite coloane in SQL Server. Ceva similar cu:

http://www.topshareware.com/OmniAudit-download-3798.hm

 

Este binevenita orice alta solutie "automatizata" in acest sens.

Multumesc 

Using Change Data Capture

Sync Services and SQL Server 2008 Change Tracking...a perfect match?

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5560

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

Pentru un proiect pe SQL 2005, am folosit "Sql Data Compare" de la RedGate - http://www.red-gate.com/products/sql_tools_overview.htm.

* Nu stiu daca "merge" si pe SQL 2000...

* Link-ul catre topshareware.com nu functioneaza ("HTTP Error 404 - File or directory not found")

O solutie pentru SQL Server 2000

http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html 

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2320807&SiteID=1