SQL Server Performance

Field defaults lost in transactional snapshot

Discussion in 'Performance Tuning for SQL Server Replication' started by dclarkesql, Jan 19, 2006.

  1. dclarkesql New Member

    Hello -

    I have been using transactional replication just fine. However I just noticed (and re-created the replication to verify this is happening) that after the Snapshot is run, the default values assigned to fields in the DB are wiped out! My application depends on these defaults when records are created, so my replicated version of the DB is hardly of any use. Any explination and/or way to control/correct for this would be greatly appreciated. Thank you.

    DC

Share This Page