Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-13 : 08:39:05
|
| mark writes "Hi allWe have SQL Server (SP2) running on NT4 and have been setting up various replication jobs. We have just discovered that when the snapshot is applied it messes up the primary keys and defaults in the subscribing databases (I presume it's using DTS). The primary key index is still there, but is no longer set to primary.Does anyone know why this happens, or is there a bug fix or what the best work-around is?Thanks in advancemarkPS It must have bahaved once because we have had replication running for several months." |
|
|
|
|
|
Replication - snapshot kills my keys and defaults