2.1.1.19 E152-02, SET TRANSACTION statement: READ ONLY and READ WRITE clauses

  • Article

V0019:

The specification states the following:

 Subclause 17.2, "<set transaction statement>":
 with <transaction access mode> of READ ONLY or READ WRITE
  
 <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>
  
 <transaction access mode> ::=
 READ ONLY
 | READ WRITE

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

Transact-SQL does not support this feature. Transact-SQL does not support transaction access modes, but equivalent functionality is available by using permissions.

See [ISO/IEC9075-1:2011] for the definition of "transaction".