Error while Altering table on Publisher Database. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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
See the last point here
http://vyaskn.tripod.com/repl_ans3.htm
Madhivanan Failing to plan is Planning to fail
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
]]>