Receiving the following error when altering a column-- Error Cannot rename column because it is being replicated

• Pam Ozer

  SSCommitted

  Points: 1722

  More actions

  May 5, 2008 at 5:06 am

  #121938

  I have a table that is replicated in two different publications. I need to rename the columns. I tried removing the tables from the replication and then altering the columns but for some reason the system thinks that the table is still being replicated. I found some documentation on this for Sql server 2000 but not 2005 and the fix for 2000 will not work in 2005. The error I am getting is Cannot alter column because table is part of replication but it isn't. It has something to with the system not dropping some information.

  Has anyone else had this problem in SQL SErver 2005?

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 5, 2008 at 12:52 pm

  #810856

  This is not the right forum for this post. I suggest that you move it to the "SS2K5 Replication" forum.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]