We have a domain joined SQL 2008 R2 server performing a snapshot database replication to a non-domain joined SQL 2008 R2 server. The snapshot replication is working with one exception. Under one of the tables, there is a Key, Constraint and Index that are part of the database. The Key and Indexes is copying over. However,
the constraint is not. Anyone seen this issue and why would the Key and Index copy but not the Constraint?
Thx in advance for any assistance provided.