Field defaults lost in transactional snapshot | SQL Server Performance Forums

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
]]>