Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    2

    Question Unanswered: To identify the Locked Row

    Hi,
    I like to know is it possible to know exactly which row is locked in a particular table ?? The table has a unique identifier column and a clustered index on it. In case of Row lock, sp_lock gives the hexadecimal number used internally by the SQL. But is it possible to get any parameter associated (like the unique identifier) with the row which is locked ?? Readpast excludes only the exclusively locked rows. If the lock is a shared lock then it also does not come to help.
    Is it possible to 'readpast' the rows which are locked irrespective of the type of lock (shared/exclusive) ???

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: To identify the Locked Row

    Q1 I like to know is it possible to know exactly which row is locked in a particular table ??
    The table has a unique identifier column and a clustered index on it. In case of Row lock, sp_lock gives the hexadecimal number used internally by the SQL.

    Q2 But is it possible to get any parameter associated (like the unique identifier) with the row which is locked ??
    A1 & A2 Theoretically, locked rows may be displayed (useful in test environments designed to demonstrate various transaction / locking concepts); but this would not really be very practical in typical production environments.

    Readpast excludes only the exclusively locked rows. If the lock is a shared lock then it also does not come to help.

    Q3 Is it possible to 'readpast' the rows which are locked irrespective of the type of lock (shared/exclusive) ???
    A3 An interesting question. (What is the application / requirement?)

Posting Permissions

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