Search

Monday, May 4, 2015

Cannot alter the table 'Table_Name' because it is being published for replication.

Today I was altering Primary key columns datatype in a table and got below error in Transaction replication.

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

I had taken following steps to solve the problem
  • Remove table from the replication.
  • Change the datatype of Primary key column.
  • Add again add table to the replication and reinitialize the publication.

No comments:

Post a Comment