November 13, 2003 at 1:52 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy