sp_rename on a replicated table

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  April 23, 2009 at 5:09 pm

  #203328

  HI,

  I want to rename a table which is used for a publication. Is it possible or do I get error. I can not test this, because we only have production replication environment.

  Thanks,

  VG

• ABAS101

  SSCommitted

  Points: 1894

  More actions

  April 23, 2009 at 7:59 pm

  #983358

  You'll get an error msg similar to this "Cannot rename the table because it is published for replication."