Changing DtaaType on the publisher

Vivek,
such a change is possible in SQL Server 2005 (using Alter
Table but not the gui on Beta2) but in SQL Server 2000 we
have one of 2 choices:
(1) Drop the subscriptions, make the change then
resubscribe
(2) You could add a new column with the new datatype
(sp_repladdcolumn), do an update on the table to populate
the column, then drop the old column (sp_repldropcolumn).
Do this again to create the column having the same
original name.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Thanks for your suggestion.
I tried the first one. I unsubscribed the subscriber and then tried changing
the length of the data type on Publisher. When I tried to save it sadi,
"Unable to modify since the table is being used for replication"
Please help
Thanks
Vivek
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:2b5801c49faf$ab274ff0$a501280a@.phx.gbl...
> Vivek,
> such a change is possible in SQL Server 2005 (using Alter
> Table but not the gui on Beta2) but in SQL Server 2000 we
> have one of 2 choices:
> (1) Drop the subscriptions, make the change then
> resubscribe
> (2) You could add a new column with the new datatype
> (sp_repladdcolumn), do an update on the table to populate
> the column, then drop the old column (sp_repldropcolumn).
> Do this again to create the column having the same
> original name.
> HTH,
> Paul Ibison
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>