is WITH(READPAST) affected by readlocks RRS feed

  • Question

  • If a transaction calls a SELECT using the table hint WITH(READPAST)... will it skip rows that are locked by other SELECT statements that are in READ COMMITTED mode and are issuing shared locks?

    ie. Does READPAST skip rows that are locked by SELECT statements, not just UPDATE and INSERT statements

    I've posted this question in the database engine forum but not sure if this is a t-sql problem.

    Friday, March 18, 2011 4:48 AM


  • It is relatively easy to test. The result: READPAST will not skip rows that only have a shared lock.


    • Marked as answer by Josh Ashwood Saturday, March 19, 2011 12:32 PM
    Saturday, March 19, 2011 11:34 AM

All replies