Altering collation on a replicated table

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply