Share via


2.1.2.40 F123, All diagnostics

V0076

The specification states the following:

 Subclause 23.1, "<get diagnostics statement>":
  
 <get diagnostics statement> ::=
 GET DIAGNOSTICS <SQL diagnostics information>
  
 <SQL diagnostics information> ::=
 <statement information>
 | <condition information>
 | <all information>
  
 ...
  
 <all information> ::=
 <all info target> <equals operator> ALL [ <all qualifier> ]
  
 <all info target> ::=
 <simple target specification>
  
 <all qualifier> ::=
 STATEMENT
 | CONDITION [ <condition number> ]
  
 <condition number> ::=
 <simple value specification>
  
 ...
  
 Conformance Rules
  
 Without Feature F123, "All diagnostics", conforming SQL language shall not contain an <all information>.

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

Transact-SQL does not support this feature.