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
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