Isolation Level

Select the transaction isolation level to use when running stored procedure tasks (Executable Type is set to SP) or report stored procedures (Executable Type is set to RPT):

• 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.