triggers - After Update errors on Memory optimized tables SqlServer -
using ef 6.1.3, sqlserver 2016. have modified tables in db memory optimized tables. functions correctly, however, when added after update trigger on non-memory optimized table following error.
sql server assertion: file: <"d:\b\s1\sources\sql\ntdbms\hekaton\engine\core\tx.cpp">, line=7434 failed assertion = '!(tx->errorobject != nullptr) || (err == nullptr || tx->temptabletx)'. error may timing-related. if error persists after rerunning statement, use dbcc checkdb check database structural integrity, or restart server ensure in-memory data structures not corrupted.
note: there predicate on table row level security uses memory optimized tables.
has else encountered this/found solution?
thanks!
Comments
Post a Comment