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 |
|
RobinCox
Starting Member
4 Posts |
 Posted - 2005-01-16 : 03:38:05
|
| When pushing a subscription to a remote SQL Server The distribution agent reports the following error ::Violation of Primary Key constraint 'PK__@snapshot_seqnos__{UniqueNumber}'. Cannot insert duplicate key in object '#{UniqueNumber}'. I have managed to locate this http://support.microsoft.com/default.aspx?scid=kb;en-us;813494Microsoft reference to the problem. It appears to indicate applying a security pack rolluphttp://support.microsoft.com/?kbid=815495will correct the problem. Before I leap in boots and all, can anyone else indicate whether they have encountered this problem and what they did to resolve it?Thnx in advance... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-16 : 03:46:13
|
| I haven't run into this specific problem, but everyone should apply ms03-031.What build of SQL 2K are you running? It should be atleast 818, which is the version ms03-031 brings you up to. you can test this with a SELECT @@VERSION in query analyzer.-ec |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-17 : 00:04:41
|
| i just reapplied the snapshot--------------------keeping it simple... |
|
|
|
|
|
|
Violation of Primary Key PK_@Snapshot_seqnos ...