November 16, 2010 at 10:47 pm
I can't alter the table column in replication database.
Please tell me how to do?
error
“Cannot alter the table 'tbl_contract_emp_master' because it is being published for replication.”
command
alter table tbl_contract_emp_master alter column PRES_ADD
varchar(200);
thanks
ananda
November 17, 2010 at 2:14 am
It’s been a while since I last worked with replication on SQL Server 2000, but as far as I remember modifying table that is published is very limited. You can add and drop column with procedures sp_repladdaddcolumn and sp_repldropcolumns, but I don’t think that you can alter an existing column. Most chances are that you’ll have to drop the table from the publication, alter the column and then add the table again to the publication.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply