MSSQLSERVER_17084

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)