|
|
|
Sets the maximum transaction isolation level at which SQL clients can operate. The supported values are:
MAX_SQL_ISOLATION_LEVEL 1 ; Support READ_COMMITTED only
MAX_SQL_ISOLATION_LEVEL 2 ; Support READ_COMMITTED and REPEATABLE_READ. (default server setting)
MAX_SQL_ISOLATION_LEVEL 3 ; Support READ_COMMITTED, REPEATABLE_READ, and SERIALIZABLE.
If a SQL client requests an isolation level that exceeds the maximum SQL isolation level specifed in the server configuration file, the SQL client operates at the maximum SQL isolation level rather than its requested isolation level.
