Using the readpast Option

Usage information for readpast.

  • readpast applies only to data-only-locked tables, and is ignored if it is specified for an allpages-locked table.

  • readpast is incompatible with the holdlock option. If both are specified in a command, an error is generated and the command terminates.

  • If readtext specifies at isolation read uncommitted, readpast generates a warning, but does not terminate the command.

  • If the statement isolation level is set to 3, readpast generates an error and terminates the command.

  • If the session-wide isolation level is 3, readpast is silently ignored.

  • If the session-wide isolation level is 0, readpast generates a warning, but does not terminate the command.