all groups > sql server replication > march 2004 >
You're in the

sql server replication

group:

Merge replication and conflict tables.



Merge replication and conflict tables. mary
3/31/2004 10:20:52 AM
sql server replication:
Hi, I configured a merge replication with pull subscription. I need to
do some changes on the table structure so, i delete the replication, do
the changes and configure the replication again.

I saw that every time the publication is configured it creates some
conflict tables but don´t delete the conflict tables that the first
publication used.

I try to delete this tables but i can´t because are system tables.

Do you know if there is a way that i can delete this tables??

Thanks a lot for your help.


*** Sent via Developersdex http://www.developersdex.com ***
Re: Merge replication and conflict tables. Emma
4/1/2004 6:18:20 AM
I was having trouble adding column to tables that are=20
being replicated using EM and I get a message saying=20
that "Cannot alter column ... because it is 'REPLICATED'.=20
I was directed to the following knowledge base article=20
listed below to correct the problem. Will using=20
sp_repladdcolumn and sp_repldropcolumn prevent this?

http://support.microsoft.com/default.aspx?scid=3DKB;EN-
US;811899


[quoted text, click to view]
Re: Merge replication and conflict tables. Hilary Cotter
4/1/2004 7:13:23 AM
If you are making schema changes you should be using sp_repladdcolumn, and
sp_repldropcolumn.

You can't delete the conflict tables using EM, but you can using
sp_droptable through ISQLW

You really don't have to delete these tables. If you are creating a new
publication SQL Server will detect these existing tables and then create new
ones based on the existing name but incrementing by 1 letter.

So conflict_pubs2_authors would be the first table, aonflict_pubs2_pubs the
second, bonflict_pubs2_pubs the third, donflict_pubs2_pubs the fourth, etc.



[quoted text, click to view]

Re: Merge replication and conflict tables. Karthik
4/2/2004 1:51:05 AM
Hi Emma

Yes. Using sp_repladdcolumn and sp_repldropcolumn would solve your problem while changing the schema for any table

Regards
AddThis Social Bookmark Button