that "Cannot alter column ... because it is 'REPLICATED'.=20
listed below to correct the problem. Will using=20
>-----Original Message-----
>If you are making schema changes you should be using=20
sp_repladdcolumn, and
>sp_repldropcolumn.
>
>You can't delete the conflict tables using EM, but you=20
can using
>sp_droptable through ISQLW
>
>You really don't have to delete these tables. If you are=20
creating a new
>publication SQL Server will detect these existing tables=20
and then create new
>ones based on the existing name but incrementing by 1=20
letter.
>
>So conflict_pubs2_authors would be the first table,=20
aonflict_pubs2_pubs the
>second, bonflict_pubs2_pubs the third,=20
donflict_pubs2_pubs the fourth, etc.
>
>
>
>"mary" <mary@dbagua.com> wrote in message
>news:eN3enz0FEHA.2876@TK2MSFTNGP09.phx.gbl...
>>
>> Hi, I configured a merge replication with pull=20
subscription. I need to
>> do some changes on the table structure so, i delete=20
the replication, do
>> the changes and configure the replication again.
>>
>> I saw that every time the publication is configured it=20
creates some
>> conflict tables but don=B4t delete the conflict tables=20
that the first
>> publication used.
>>
>> I try to delete this tables but i can=B4t because are=20
system tables.
>>
>> Do you know if there is a way that i can delete this=20
tables??
>>
>> Thanks a lot for your help.
>>
>>
>> *** Sent via Developersdex=20
http://www.developersdex.com ***
>> Don't just participate in USENET...get rewarded for it!
>
>
>.