MSSQLSERVER_17083

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 17083
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name P3_HEKATON_NOT_ATOMIC
Message Text The body of a natively compiled stored procedure must be an ATOMIC block.

Explanation

The body of a natively compiled stored procedure did not have an ATOMIC block.

User Action

A natively compiled stored procedure must contain an ATOMIC block. 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)