sql server 2005 replication article conflict

Posted by Daniel on Stack Overflow See other posts from Stack Overflow or by Daniel
Published on 2010-12-20T23:31:22Z Indexed on 2010/12/23 5:54 UTC
Read the original article Hit count: 203

Hi all,

I have a sql server 2005 database that I want to setup replication for. The problem is that the database has two schemas both of which have a table with the same name in it.

For some reason even though the tables are in different schemas the replication creation fails when done through management studio due to conflicting article names (i assume its trying to create the same name for both tables in the different schemas).

Is there any workaround for doing this in the studio, I can probably write a script or program to do this but just for this one thign is a bit annoying and it probably wont be allowed to run in production.

Perhaps there is a hot fix or something I'm not aware about?

Cheers,

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about database-replication