problems with the distribution job

Last Post 11 Aug 2005 06:18 AM by eramgarden_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kristina
New Member
New Member

--
05 Aug 2005 05:40 AM
We are running 2000 SP4. I am trying to get replication going and all the wizards are going well, but I keep getting this error on the subsriber. Has anyone seen this or know what to do?

Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__639A5B9D'. Cannot insert duplicate key in object '#62A63764'. The step failed.
eramgarden_SQL
New Member
New Member

--
11 Aug 2005 06:18 AM
You're tables must have primary key. Now, if your table has duplicate key, it wont replicate. See what row has duplicate key, remove (if possible) and retry
You are not authorized to post a reply.

Acceptable Use Policy