2.1.2.102 F761, Session management

V0138:

The specification states the following:

 Subclause 19.1, "<set session characteristics statement>":
  
 <set session characteristics statement> ::=
 SET SESSION CHARACTERISTICS AS <session characteristic list>
  
 <session characteristic list> ::=
 <session characteristic> [ { <comma> <session characteristic> }... ]
  
 <session characteristic> ::=
 <session transaction characteristics>
  
 <session transaction characteristics> ::=
 TRANSACTION <transaction mode> [ { <comma> <transaction mode> }... ]
  
 ...
  
 Conformance Rules
  
 Without Feature F761, "Session management", conforming SQL language shall not contain a <set session characteristics statement>.
  
 Subclause 19.5, "<set catalog statement>":
  
 <set catalog statement> ::=
 SET <catalog name characteristic>
  
 <catalog name characteristic> ::=
 CATALOG <value specification>
  
 ...
  
 Conformance Rules
  
 Without Feature F761, "Session management", conforming SQL language shall not contain a <set catalog statement>.
  
 Subclause 19.6, "<set schema statement>":
  
 <set schema statement> ::=
 SET <schema name characteristic>
  
 <schema name characteristic> ::=
 SCHEMA <value specification>
  
 ...
  
 Conformance Rules
  
 Without Feature F761, "Session management", conforming SQL language shall not contain a <set schema statement>.
  
 Subclause 19.7, "<set names statement>":
  
 <set names statement> ::=
 SET <character set name characteristic>
  
 <character set name characteristic> ::=
 NAMES <value specification>
  
 ...
  
 Conformance Rules
  
 Without Feature F761, "Session management", conforming SQL language shall not contain a <set names statement>.

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

Transact-SQL does not support this feature.