SQL Server Performance

Error 4928 on altering not replicated column

Discussion in 'SQL Server 2005 Replication' started by jan.wagner, Nov 5, 2007.

  1. jan.wagner New Member

    Hi,
    I am trying to alter a column on an not replicated table, but I'm getting the following error message:
    Cannot alter column because it is 'REPLICATED'.
    The table I want to alter was replicated until I dropped replication to alter it.
    I found the following on MS KB: http://support.microsoft.com/?scid=kb%3Ben-us%3B811899&x=15&y=13
    Unfortunately this KB article is for SQL Server 2000, but I'm using SQL Server 2005. I had a look into syscolumns anyway, seeing that the column I want to alter has colstat >= 4096.
    Any ideas how to mark this table/column as not replicated?
    Regards,
    Jan
  2. techbabu303 New Member

    I Hope this link helps
    http://www.replicationanswers.com/AddColumn.asp
    Procedure referred is
    exec sp_repldropcolumn @source_object = 'tEmployees'
    , @column = 'Forename'
    But would suggest to research the implications before doing it.
    Cheers
    Sat
  3. jan.wagner New Member

    Hi Sat,
    thanks for your reply. Unfortunately this only works with SQL 2000 as subscribers but I'm using SQL 2005.
    I found the following workaround:
    1. Create a new table based on the table I needed to change with all changes
    2. copy all data from old to new
    3. Rename old table
    4. Rename new table
    Regards,
    Jan
  4. techbabu303 New Member

    Thx this is instresting stuff.
    Cheers
    Sat

Share This Page