August 29, 2003 at 1:58 pm
I am having problems pushing a subscribtion when specifying - No, the subscriber already has the schema and data. Each time I try this I get the following error Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__484E27E5'. Cannot insert duplicate key in object '#475A03AC'.
(Source: MMSSQLQ1 (Data source); Error number: 2627).
If I subscribe and intialize the schema and data, there is no problem.
I apply changes to the publishing db and subscribing db and update the replication sp's also before sunscribing.
Is there a setting I am missing?
Any help would be great.
Thanks.
September 1, 2003 at 8:00 am
This was removed by the editor as SPAM
September 2, 2003 at 10:40 am
Not that I know of. It looks like you're out of sync somehow. Trying turning on the verbose logging for the distribution agent so you can some more details.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply