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:
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 Center.