Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Receiving the following error when altering a column-- Error Cannot rename column because it is being replicated Expand / Collapse
Author
Message
Posted Monday, May 05, 2008 5:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 24, 2010 9:47 AM
Points: 120, Visits: 376
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?
Post #494851
Posted Monday, May 05, 2008 12:52 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
This is not the right forum for this post. I suggest that you move it to the "SS2K5 Replication" forum.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #495183
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse