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.

-
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Passwords Made Easy

Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...

  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • DCOB Fault
    If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
  • Restore Windows App after a Crash.
    If you have a situation that requires an application to always be up then try   Restart program after a crash downloadable from  https://w-s...