SQL Server Performance

Replication from Spanish Forum

Discussion in 'Performance Tuning for SQL Server Replication' started by Luis Martin, Jul 17, 2004.

  1. Luis Martin Moderator

    Hi:

    I have one database with replication.
    When I try to change one table, using ALTER, there is a message like: Can't alter a table because belong to a replication.

    Any help would appreciate.

    Lenin Rodriguez



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  2. satya Moderator

    What is the version of SQL Server used?
    In order to perform any schema changes like renaming a table you must disable replication and re-enable to affect the process.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page