When logging an UPDATE operation, the MS SQL Server records only changed data to the TLOG. This is not enough information for the CDC agent to provide before and after images for UPDATE statements. To solve this problem, you must turn Replication on in the MS SQL Server. This replaces the UPDATE changes entered in the log with DELETE/INSERT pairs.
An MS SQL system administrator must set up the database for replication. The system administrator must do this through the MS SQL Server’s publishing wizard in the MS SQL Server’s Enterprise Manager. Follow the instructions provided by the wizard or see the MS SQL Server documentation. The following should be added to the database’s definitions:
■ A new Distribution database
■ A replication entry
■ A replication monitor entry


LinkBack URL
About LinkBacks




Reply With Quote
