Error while Altering table on Publisher Database.

Hi

I have Transaction Replication with Publisher and Subscriber database on
Two different Boxes.When I tried to Alter table using
" ALTER TABLE CONTRACT_SITE ALTER COLUMN SITE_NAME NVARCHAR(100) NULL; "

I encountered following message......

Server: Msg 4929, Level 16, State 1, Line 1
Cannot alter the table 'CONTRACT_SITE' because it is being published
for replication.

Please help me fix this problem preferablely without removing
Replication.

Thanks








raj

Ok Cool,

Got the Problem fixed.But How to Set the replication back again.

Thanks,


raj

It doesn't so cool <img src='/community/emoticons/emotion-1.gif' alt='' /><br />If you are using MS SQL 2k, it is better to use sp_repladdcolumn/sp_repldropcolumn SPs.<br />What version do you use?<br /><br />WBR, Vlad A. Scherbinin

It is MS SQL 2k.

How to get that Replication Back ?

Thanks



raj

As usual. With the use of the Enterprise Manager or stored procedures.
(If you haven't script your publication and subscriptions and you don't have backup).

WBR, Vlad A. Scherbinin