Post reply

Perform some custom inserts during or after replication

  • July 10, 2007 at 11:45 am

    #718370

    Modify the appropriate replication stored procedures to do just that ?


    * Noel

  • July 22, 2007 at 7:57 am

    #721384

    Oops - I missed the "during" bit...

    /Vincent

  • July 22, 2007 at 7:57 am

    #721383

    You could also consider writing a stored procedure that does what you want and insert a job step to the distribution job after the Run Agent step in which you call that stored procedure. Ensure you adjust the On Success and On Failure actions accordingly.

    /Vincent

     

     

  • July 23, 2007 at 11:16 am

    #721584

    You could also add triggers to the concerned tables. Note that modifying the insert proc or adding a subscriber side trigger are both brittle - could get dropped if you resnapshot and use the default settings.

    Andy
    Connect with me on LinkedIn

  • July 23, 2007 at 12:52 pm

    #721627

    Thanks!  Good to know.  That is what I ended up doing was adding triggers to the concerned tables.

Viewing 5 posts - 1 through 6 (of 6 total)

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