April 27, 2015 at 6:15 am
Hi all,
Need some help with this issue.
I have two publications replicating two tables with the same name. They both go to the same subscriber DB but the destination tables have different names e.g.
Publisher1: Table1 -> Subscriber DB: Table1
Publisher2: Table1 -> Subscriber DB: Table1a
The problem I have is that the replication procs both have the same name of the published tables e.g. sp_MSupd_Table1.
The tables have very different schemas and one proc is being overwritten by the other causing one of the replications to fail with data errors.
I need to rename one of the procs to remove the clash so I end up with something like:
sp_MSupd_Table1
sp_MSupd_Table1a
I'm not sure if this can be done by simply recreating a new system proc with the appropriate name.
FYI, I can't change any of the source object names. I have to find a resolution with the system procs.
Any advice is appreciated.
April 27, 2015 at 8:31 am
I've resolved this by editing the create replication script to use destination tables names for the proc.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply