MSSQLSERVER_41368
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 41368 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | SQL_IMPLICIT_AND_EXPLICIT_TX_NOT_SUPPORTED |
| Message Text | Accessing memory optimized tables using the READ COMMITTED isolation level is supported only for autocommit transactions. It is not supported for explicit or implicit transactions. Provide a supported isolation level for the memory optimized table using a table hint, such as WITH (SNAPSHOT). |
Explanation
Accessing memory-optimized tables using the READ COMMITTED isolation level is supported only for autocommit transactions. For more information, see Transactions with In-Memory Tables and Procedures.
When accessing a memory-optimized table from an explicit transaction that was started with BEGIN TRANSACTION, or from an implicit transaction, if IMPLICIT_TRANSACTIONS is set to ON, the READ COMMITTED isolation level is not supported.
User Action
When accessing a memory-optimized table from an explicit or implicit READ COMMITTED transaction, use SNAPSHOT to access the table. This can be achieved by using the table hint WITH (SNAPSHOT) (for more information, see Transactions with In-Memory Tables and Procedures) or by setting the database option MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT to ON (for more information, see ALTER DATABASE SET Options (Transact-SQL)).
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for