Results 1 to 2 of 2

Thread: row locking

  1. #1
    Join Date
    Sep 2003
    Posts
    7

    Unanswered: row locking

    I had a lock on page 2234, row 12 of the table.

    is there any way to find which data row this location
    corresponds to?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97

    Re: row locking

    Originally posted by tiggerwave
    I had a lock on page 2234, row 12 of the table.

    is there any way to find which data row this location
    corresponds to?
    Use dbcc page:

    dbcc page("yourbd", 2234, 1)

    Regards,
    Mariano Corral

Posting Permissions

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