I'm using the READPAST hint in MS SQL 2005, to allow select statements to read data in a lock without waiting for it to be released. I think I understand it, but need a bit of clarification on the following in red;
Specifies that the Database Engine not read rows and pages that are locked by other transactions. The Database Engine skips past the rows or pages instead of blocking the current transaction until the locks are released. READPAST can only be specified in transactions operating at the READ COMMITTED or REPEATABLE READ isolation levels. When READPAST is specified both row-level and page-level locks are skipped. READPAST can be specified for any table referenced in an UPDATE or DELETE statement, and any table referenced in a FROM clause. When specified in an UPDATE statement, READPASTis applied only when reading data to identify which records to update, regardless of where in the statement it is specified. READPAST cannot be specified for tables in the INTO clause of an INSERT statement. Read operations that use READPAST do not block. Update or delete operations that use READPAST may block when reading foreign keys or indexed views, or when modifying secondary indexes. -------------------------------------------- can only be specified in transactions operating at the READ COMMITTED or REPEATABLE READ isolation levels I'm not quite sure what that means, does it refer to the SELECT statement using the READPAST hint or the statement using the locks? any help much appreciated. -- http://www.clickfind.com.au The new Australian search engine for businesses, products and services --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
