Isolation Level
Select the transaction isolation level to use when running stored procedure tasks or
report stored procedures.
When Executable Type is set to or when Executable Type is set to , these situations are true:
- : 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.
- : 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.