2.1.2.36 F121, Basic diagnostics management

V0072

The specification states the following:

 Subclause 17.3, "<transaction characteristics>":
  
 <transaction characteristics> ::=
 [ <transaction mode> [ { <comma> <transaction mode> }... ] ]
  
 <transaction mode> ::=
 <isolation level>
 | <transaction access mode>
 | <diagnostics size>
  
 ...
  
 <diagnostics size> ::=
 DIAGNOSTICS SIZE <number of conditions>
  
 <number of conditions> ::=
 <simple value specification>
  
 ...
  
 Conformance Rules
  
 Without Feature F121, "Basic diagnostics management", conforming SQL language shall not contain a <diagnostics size>.
  
 Subclause 13.4, "<SQL procedure statement>":
  
 <SQL executable statement> ::=
 <SQL schema statement>
 | <SQL data statement>
 | <SQL control statement>
 | <SQL transaction statement>
 | <SQL connection statement>
 | <SQL session statement>
 | <SQL diagnostics statement>
 | <SQL dynamic statement>
  
 ...
  
 <SQL diagnostics statement> ::=
 <get diagnostics statement>
  
 Subclause 23.1, "<get diagnostics statement>":
  
 <get diagnostics statement> ::=
 GET DIAGNOSTICS <SQL diagnostics information>
  
 <SQL diagnostics information> ::=
 <statement information>
 | <condition information>
 | <all information>
  
 ...
  
 Conformance Rules
  
 Without Feature F121, "Basic diagnostics management", conforming SQL language shall not contain a <get diagnostics statement>.
  

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

Transact-SQL does not support this feature.