Edit

MSSQLSERVER_17084

  • Article

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 17084
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name P3_ATOMIC_WITH_MISSING_OPTION
Message Text The WITH clause of BEGIN ATOMIC statement must specify a value for the option '%ls'.

Explanation

The WITH clause of BEGIN ATOMIC statement did not specify a value for an option.

User Action

ATOMIC blocks require values for the WITH options TRANSACTION ISOLATION LEVEL and LANGUAGE. For example::

BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE= N'us_english')

For more information, see In-Memory OLTP (In-Memory Optimization).

See Also

In-Memory OLTP (In-Memory Optimization)