Post reply

Transactions across multiple databases

  • May 31, 2006 at 5:23 pm

    #366283

    Hi,

    I need to select a record in a second database with UPDLOCK and according to some criteria, either update it or not. I created a SP with a transaction in the first datebase, including the SELECT to the table in the second database. I'm having problems, SQL Server does not seem to handle locking on another database correctly. Any ideas?

    Thanks

  • June 1, 2006 at 3:32 am

    #641119

    if you are the only one who is updating the other table then you can pull the records in tmp table check the condition then if needed update the table in other server.

    ------------
    Prakash Sawant

    http://psawant.blogspot.com

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

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