SQL Server Performance

Error while Altering table on Publisher Database.

Discussion in 'Performance Tuning for SQL Server Replication' started by krajdba, Jul 19, 2005.

  1. krajdba New Member

    Hi

    I have Transaction Replication with Publisher and Subscriber database on
    Two different Boxes.When I tried to Alter table using
    " ALTER TABLE CONTRACT_SITE ALTER COLUMN SITE_NAME NVARCHAR(100) NULL; "

    I encountered following message......

    Server: Msg 4929, Level 16, State 1, Line 1
    Cannot alter the table 'CONTRACT_SITE' because it is being published
    for replication.

    Please help me fix this problem preferablely without removing
    Replication.

    Thanks








    raj
  2. Madhivanan Moderator

  3. krajdba New Member

    Ok Cool,

    Got the Problem fixed.But How to Set the replication back again.

    Thanks,


    raj
  4. Ray D New Member

    It doesn't so cool <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />If you are using MS SQL 2k, it is better to use sp_repladdcolumn/sp_repldropcolumn SPs.<br />What version do you use?<br /><br />WBR, Vlad A. Scherbinin
  5. krajdba New Member

    It is MS SQL 2k.

    How to get that Replication Back ?

    Thanks



    raj
  6. Ray D New Member

    As usual. With the use of the Enterprise Manager or stored procedures.
    (If you haven't script your publication and subscriptions and you don't have backup).

    WBR, Vlad A. Scherbinin

Share This Page