Isolation Level

Select the transaction isolation level to use when running stored procedure tasks or report stored procedures.

When Executable Type is set to SP or when Executable Type is set to RPT, these situations are true:

  • Read Committed: All queries run from this stored procedure see only data for which the query can get a shared lock. No reads of uncommitted data are performed.
  • Read Uncommitted: All queries run from this stored procedure can read uncommitted data. Use this option carefully, since it can display data that has not yet been committed in the database.

If no isolation level is set in this form, the stored procedure uses the global Collection Read Mode value from the Process Defaults form. If that value does not exist, the stored procedure uses Read Committed as the transaction isolation level.