Home Forums SQL Server 2008 SQL Server 2008 - General DETECT ROWS CHANGED IN A TABLE to transfer in a datawarehouse RE: DETECT ROWS CHANGED IN A TABLE to transfer in a datawarehouse
ScottPletcher
SSC Guru
Points: 100946
More actions
November 21, 2013 at 11:16 am
#1668201
Change Tracking should handle your situation easily and completely. IIRC, CT requires that the table have a PRIMARY KEY defined.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.