SQL Server Performance Forum – Threads Archive
Field defaults lost in transactional snapshot
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]]>