Post reply

Transactions across multiple databases

  • May 31, 2006 at 5:34 pm

    #114387

    Hi,

    I have a SP that needs to select a row on a second database and according to some criteria, update it or not. I used BEGIN TRAN before the SELECT WITH (UPDLOCK) on the table in the second DB, but SQL Server does not seem to handle transactions across multiple databases very well. I get transactions count errors. Any ideas? How do I control transactions across multiple databases?

    Thanks

    Felipe

  • June 5, 2006 at 8:58 am

    #641745

    There are several tools that can help you:

    1. SQL Server 2005 Service Broker

    2. Microsoft Biztalk Server

    3. Distributed Transaction Coordinator that helps with linked servers, OPENROWSETs, updatable distributed views etc. You have to follow the systax exactly and use Begin Distributed Transaction statement:

    BEGIN DISTRIBUTED { TRAN | TRANSACTION }      [ transaction_name | @tran_name_variable ] [ ; ]

    Regards,Yelena Varsha

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

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