Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    47

    Question Unanswered: Row locking in a table in Remote Database

    Hi,
    I want to lock a row in a table which is in Remote Database.
    I tried XLOCK but it says that XLOCK cannot be used in Remote Database.
    See if someone could help me.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    When saying "Remote", do you mean linked server, openrowset, etc.? For these types of tasks the best approach would be...not to use queries that involve remote joins/filtering, that is initiated locally. Best is to leave it up to the engine of the remote location, and invoke a procedure that would be executed local to the data source.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •