Friday, 7 November 2014

Cannot Alter Table Being Used For Replication



If you have a table you wish to change that is being replicated you may have trouble changing it and get an error saying that Cannot alter the table 'Table Name' because it is being used for replication.

To get round this  I stopped the replication job then tried to change the table through management studio but this still failed.  I then opened a query window and tried to alter the table with a script 


ALTER TABLE table name ADD column_b VARCHAR(20) NULL ;
 
 and bingo it worked.

No comments:

Post a Comment

Chrome 138 the last supported

Chrome 138 the last supported  Hey Everyone, Chrome 138 is the last version of Chrome that will support Android 8.0 (Oreo) and Android 9.0 (...