SQL Server Performance

Change field size for replicated database

Discussion in 'SQL Server 2005 Replication' started by tarekj, Jun 16, 2009.

  1. tarekj Member

    Hi,
    How can I change field size for replicated database?, when I try to do so I get the message"
    - Unable to modify table. Cannot drop the table 'MyTable' because it is being used for replication
    Is there a way to do so without dropping the replication?
  2. ndinakar Member

    Are you dropping the column or modifying it? I think you can do an ALTER TABLE... while its replicated...If the table is not to obig (< few hundred thousand rows) you can just drop the table from replication, make your schema changes and add it back and replication will create a snapshot of just that table...
  3. tarekj Member

    I am increasing the size from nvarchar(100) to nvarchar(200), when I do this from Management Studio it says :
    'ItemsDirectory' table
    - Unable to modify table.
    Cannot drop the table 'dbo.ItemsDirectory' because it is being used for replication.

Share This Page