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