问题:
sql server 2000 sp3 数据库复制
报错:{call sp_MSget_repl_commands(6, ?, 0, 7500000)}
违反了 PRIMARY KEY 约束 'PK__@snapshot_seqnos__1B8078A1'。不能在对象 '#1A8C5468' 中插入重复键。
Solution: Change of store procedure in distibution: sp_MSget_repl_commands from: declare @snapshot_seqnos table (subscription_seqno varchar(16) primary key) in: declare @snapshot_seqnos table (subscription_seqno varbinary(16) primary key)