Cannot drop the table <TableName> because it is being used for replication
13,118
As the error says the table is used for replication, meaning it's an article in a replication publisher. To be able to modify the table you should remove it from replication, then update the schema, afterwards add it again in the replication. After adding it again you will have to reinitialize the subscriptions to pick up the modified table schema.
Author by
pramod maurya
Updated on September 01, 2022Comments
-
pramod maurya over 1 year
I am unable to modify the structure of a table in a database. database used for replication. I am getting This error
-
pramod maurya about 8 yearsmy database replicate from more then 30 clients so if there is any other option that i can try?