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

    Question Unanswered: Row locking in a table in Remote Database

    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
    San Antonio, TX
    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