replication, identity, defaults
I want to apply an hourily snapshot replication between my live webserver and my development server. The idea being i'd be able to work on updated info and have a recent back up which i could import to the webserver if the worst came to the worst.
The primary keys are aren't being set, which i gather is just tough but not a major problem as long as you make the column not for replication?
However the real prob is the default values! My code relies on the defaults and this is causing real problemas as they are always dropped on the replication and code relies on the values sometimes. Can anyone help?