| title | MSSQLSERVER_17084 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | e579d104-3307-4edd-8587-b14ecbc02ed9 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
| Product Name | [!INCLUDEssNoVersion] |
| 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'. |
The WITH clause of BEGIN ATOMIC statement did not specify a value for an option.
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).