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#