SET TRANSACTION ISOLATION LEVEL

Controls the locking and row versioning behavior of Transact-SQL statements issued by a connection .

Syntax

SET TRANSACTION ISOLATION LEVEL
    { READ UNCOMMITTED
    | READ COMMITTED
    | REPEATABLE READ
    | SNAPSHOT
    | SERIALIZABLE
    }

Remarks

Argument values are ignored and do not change the default behavior.

Permissions

Requires membership in the public role.

Examples

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

See Also