Share via

2.1.2.217 T251, SET TRANSACTION statement: LOCAL option

V0253:

The specification states the following:

 Subclause 17.2, "<set transaction statement>":
  
 <set transaction statement> ::=
 SET [ LOCAL ] TRANSACTION <transaction characteristics>
  
 ...
  
 Conformance Rules
  
 Without Feature T251, "SET TRANSACTION statement: LOCAL option", conforming SQL language shall not contain a <set transaction statement> that immediately contains LOCAL.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.