Hello,
I have an application that uses merge replication we have a SQL 200 server
and the client use MSDE 2.0
I have a subscriber that changed there computer name and it broke the
application
After that I created a script that changed the MSDE name on there computer
using the stored procedures sp_dropserver and sp_addserver and the
application replicated once.
The next time they replicated they got the error
"The merge process could not initialize the subscription."
"{?=call sp_MSaddanonymousrepica (?,?,?,?,?,?)}"
"The subscription already exists."
I did some testing it seems to change the name fine and sync but after you
reboot you get the error - I assume when you stop and start sql services
There must be a table on our server that references the subscription name
that needs changed from the old computer name to the new but I cant find it.
Any help anyone could give me would be appreciated
Thanks,
Jason Alspaugh
jalspaugh@modernfold.com