Post reply

Unable to alter table while replication

  • September 29, 2008 at 6:10 am

    #198920

    I have implemented snapshot replication. I am using SQL 2005 default instances in both the systems. When i try to modify the table getting error message 'Can't alter the table because it is being user for replication'. Please assist me how to solve this issue.

  • September 29, 2008 at 6:22 am

    #878346

    When i try to modify the table

    How did you try to modify the table? Using GUI or ALTER TABLE command?

    Try ALTER TABLE command.

    Otherwise, temporarily remove this table from the publication and readd it after altering.

  • September 29, 2008 at 6:37 am

    #878353

    You can alter objects using the GUI if you go through the replication UI. Once you are replicating an article, you have to use the replication UI to make schema changes so they can be properly handled.

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

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