Problem with sp_repldropcolumn propagation

Hi,
Im tyring to modify a column datatype in a replicated table using
sp_repladdcolumn and sp_repldropcolumn. First I create a new column
that is propagated to the subscriber, but when I drop a column with
sp_repldropcolumn the change is not propagated to the subscriber.
Does anyone has an idea of why this is happening?
Thanks,
Diego
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Replication-...ict237980.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=827285
Some columns cannot be dropped, i.e. columns which are part of PKs. Is this
the case? Can you drop it through EM? Right click on your publication,
select Properties, click on the Filter Columns tab and try to drop it there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Diego" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_827285_2d4aa9fc6f9f611260ea17bddcfcd7da@.dbf orumz.com...
> Hi,
> I'm tyring to modify a column datatype in a replicated table using
> sp_repladdcolumn and sp_repldropcolumn. First I create a new column
> that is propagated to the subscriber, but when I drop a column with
> sp_repldropcolumn the change is not propagated to the subscriber.
> Does anyone has an idea of why this is happening?
> Thanks,
> Diego
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/Replication-...ict237980.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=827285
|||"" wrote:
> Some columns cannot be dropped, i.e. columns which are part of
> PKs. Is this
> the case? Can you drop it through EM? Right click on your
> publication,
> select Properties, click on the Filter Columns tab and try to
> drop it there.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Diego" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:4_827285_2d4aa9fc6f9f611260ea17bddcfcd7da@.dbf orumz.com...
> using
> column
> column with
> subscriber.
> standards
> http://www.dbforumz.com/Replication-...ict237980.html
> abuse:
> http://www.dbforumz.com/eform.php?p=827285
Hillary,
The column is not a PK. Ive also could drop the column with
sp_repldropcolumn in the distributor, the problem is that the change
is not propagated to the subscription.
This is not the case with the sp_repladdcolumn that is added in both
places. For example to replace the field data type (thats what im
trying to do) where you run a sp_repldropcolumn before a
sp_repladdcolumn after the second command is run ive get an error in
the distribution agent that says it cannot add a column with the same
name.
Thank you very much,
Diego