Post reply

Can only use IF UPDATE within a CREATE TRIGGER statement.

  • May 17, 2005 at 5:24 am

    #86542

    I am receiving the following error when running the snapshot agent. 'Can only use IF UPDATE within a CREATE TRIGGER statement'

    Can anyone please shed any light on this error.

    I am new to replication and I can't find any information anywhere about this statement.

  • May 18, 2005 at 2:24 am

    #559502

    Are you replicating a stored procedure or UDF which has the 'IF UPDATE' statement in it?

    Paul Ibison, SQL MVP


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • May 18, 2005 at 8:26 am

    #559589

    i am replicating 4 tables only, one of which has two triggers as dependencies. Both triggers have 'not for replication' on them on both the publisher and subscriber.

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

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