Post reply

alter trigger

  • February 7, 2007 at 3:05 pm

    #171336

    Hi,

    What I have is a sql server 2005 that is a subscriber.  I'm tring to add a trigger to a table and I get this error. 

    Msg 21531, Level 16, State 1, Procedure sp_MSmerge_altertrigger, Line 67

    The DDL statement cannot be performed at the Subscriber or Republisher.

    Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181

    The DDL operation failed inside merge DDL replication manipulation.

    Msg 3609, Level 16, State 2, Procedure Insert_tblFreight, Line 9

    The transaction ended in the trigger. The batch has been aborted.

    Does anyone have any ideas where I do not have to drop the subscription and readd it.

    Thanks

    Mark

  • February 7, 2007 at 5:30 pm

    #688441

    Try after disabling the publication property on the "subscription options".. Under Schema replication...Replication schema chanes.. make this option to FALSE and then create the trigger...by default this property is TRUE...

     

    MohammedU
    Microsoft SQL Server MVP

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

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