Altering collation on a replicated table

• Gary Manino

  SSC Veteran

  Points: 227

  More actions

  April 29, 2004 at 7:21 am

  #82569

  I've restored a replicated database and executed sp_removedbreplication.  However, when executing an alter table statement to modify the collation I get the following error:

  Server: Msg 4928, Level 16, State 1, Line 1

  Cannot alter column 'bgrp_id' because it is 'REPLICATED'.

  Server: Msg 4928, Level 16, State 1, Line 1

  Cannot alter column 'menu_access_ind' because it is 'REPLICATED'.

  Server: Msg 4928, Level 16, State 1, Line 1

  Cannot alter column 'menu_name' because it is 'REPLICATED'.

  SQL Statement:

  alter table bgrp_menu alter column bgrp_id char(6) COLLATE SQL_Latin1_General_Cp1_CI_AS

  go

  alter table bgrp_menu alter column menu_access_ind char(1) COLLATE SQL_Latin1_General_Cp1_CI_AS

  go

  alter table bgrp_menu alter column menu_name varchar(6) COLLATE SQL_Latin1_General_Cp1_CI_AS

  go

  Is there something else i need to run to clear the replication?

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 30, 2004 at 2:51 pm

  #504894

  Run sp_helpArticle 'PublicationName' from the ex published database.

  If there are still articles in there, try dropping them with sp_droparticle.

  To remove replication it is always better to use the wizards.