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 |
|
gaupa@zcon.net
Starting Member
2 Posts |
 Posted - 2006-07-29 : 01:50:36
|
| Hi everyone,I have a VB application thru which I am pulling the subscriptions from the Server. I have a distributed environment and every client should transfer there data to the server at some periodic timings.The details for the databases are as:1)Publisher : SQL SERVER 2005 2)Subscriber : MSDE sp4Case 1: When i created one publication 'TEST1' and configured at Client for pull subscription then it will work after that i prepare a second publication 'TEST2' and same steps done for 'TEST2' then it also work.Case 2: When i created two publications 'TEST1' and 'TEST2' and configured at Client for pull subscription then first publication any of the one it will work the other subscriation it will not work. It will raise following error on Client sideThe ERROR messages are like :1)Violation of UNIQUE KEY constraint 'unique_pubsrvdb'. Cannot insert duplicate key in object 'sysmergesubscriptions'."2){call sp_MSaddinitialpublication (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?,?,?,?, ?)}"3)The merge process could not initialize the subscriptionI found on internet that PUSH subscription will solve it some how, but I don't want to go for PUSH subscriptions. If you have any idea then please pass to me.Thanks in advance. |
|
|
|
|
|
|
|
Merge Publication err:Violation of UNIQUE KEY cons