Share via


2.1.2.38 F121-02, SET TRANSACTION statement: DIAGNOSTICS SIZE clause

V0074

The specification states the following:

 Subclause 17.2, "<set transaction statement>":
  
 <set transaction statement> ::=
 SET [ LOCAL ] TRANSACTION <transaction characteristics>
  
 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>

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

Transact-SQL does not support this feature.