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