Posted by Greg D. Moore \(Strider\) on 06/09/06 00:58

"Brian Wotherspoon" <bwotherspoon2002@yahoo.co.uk> wrote in message
news:zjThg.1$GO4.793@news.uswest.net...
>
> Hi all,
>


Try sp_repladdcolumn.

Generally in a case like this, I make it a multi-step process.

sp_repladdcolumn and add say "SerialNumberTemp"

Then update the published table so SerialNumberTemp= SerialNumber.

Then, sp_repldropcolumn on SerialNumber

then add it the way I want.

Then copy the data back

Then drop the temp column.



> I'm using SQL Server 2000 SP3 to store data for real time transaction
> processing.
>
> I have set up replication to another server using a push subscription to
> give me immediate backup.
>
> I need to alter the data type of one of the columns and am using the
> following basic sql:
>
>
> alter table Voucher
> alter column SerialNumber varchar(20) NOT NULL
>
> However I keep getting this error message:
>
> Server: Msg 4929, Level 16, State 1, Line 1
> Cannot alter the table 'Terminals' because it is being published for
> replication.
>
> Is there anything I can do to allow this update taking place, short of
> deleting the subscription and recreating it. (I want to try and avoid
> this as the same update needs to be applied to about 10 databases that
> are also replicated in the same way).
>
> All help is appreciated.
>
> Brian.
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]