Posted by MC on 10/02/06 15:26

Well, you cant alter schema involved in replication all that easily. For
this, you can use sp_addmergecolumn (not certain if the name is correct but
its close). If you post other code samples we can try to see what can be
done


MC


"Giacomo" <no_spam@grazie.it> wrote in message
news:op.tgst4zpwt6znx9@tpprog002.ccvtech.com...
>
> Hi,
>
> I've the following error message:
>
> ---------------
> ALTER TABLE [dbo].[AnagraficoAutomezzi]
> ALTER COLUMN [CodiceXTrascodifica] varchar(10)
> Go
>
> Server: messaggio 4929, livello 16, stato 1, riga 1
> Cannot alter table 'AnagraficoAutomezzi' because it is being published for
> replication.
> ---------------
>
> This is only part of a script with much more alter table.
>
> How can I lunch the script without this problem?
>
> Thanks for your help!
> Giacomo
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

• Next in forum: Urgent requirements ----- Oracle Apps Finance Functional
• Prev in forum: Re: Blank Password Policy problem
• Thread view: Re: [help] ALTER TABLE: error message 4929

[Reply to this message]