Post reply

Sharing of cross db triggers across 2 servers.

  • November 13, 2003 at 1:52 pm

    #63363

    We currently have triggers that run across databases. we'r in process of getting another server. What to find out the posibilities of moving some databases to the new server. But the issue is we have triggers that run across databases. i.e if a record is updated in db A on table A, the trigger fires to update db B table A. Is this posibble across servers/ has anyone used triggers across servers. Any info would be appreciated. Thanks.

  • November 13, 2003 at 2:09 pm

    #481971

    This should be possible using linked servers. The downside however is that if the second server is unreachable, the whole transaction will fail.

    Maybe someone knows of a workaround?

  • November 13, 2003 at 6:33 pm

    #481994

    This might be a point at which to use MSMQ to forward the results to the other server in a structured guaranteed manner.

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

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