SET TRANSACTION

The SET TRANSACTION statement sets the isolation level for the current unit of work. You can set the isolation level to one of the following values:

Example:

The following SET TRANSACTION statement sets the isolation level to SERIALIZABLE.

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 

For more information, see SET TRANSACTION in the SQL Reference topic in the Information CenterLink to Information center.