Home Forums SQL Server 2005 T-SQL (SS2K5) How to update/roll back two tables in separate Dbs from Stored Procedure - Take 2 RE: How to update/roll back two tables in separate Dbs from Stored Procedure - Take 2

  • August 14, 2012 at 10:44 pm

    #1525878

    I guess my questions would be...

    1. Do the tables have to be "dual mastered"? That is, can both servers make an update to the email table? Or just one?

    2. What do you want to have happen when one of the two servers are down?

    3. What do you want to have happen when the down server comes back up?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)