MS SQL Server 2016 In-Memory OLTP

Asked Jan 22 '19 at 08:25

Active Jan 22 '19 at 08:27

Viewed 95 times

I want to migrate a single table to be In-Memory, and I followed these steps:

edited Jan 22 '19 at 08:27

Dale K

asked Jan 22 '19 at 08:25

1

Presumably you have a DDL trigger that you need to temporarily disable – Martin Smith Jan 22 '19 at 08:37
No, I don't have any kind of triggers – Ⲁⲅⲅⲉⲗⲟⲥ Jan 22 '19 at 09:00
2

You almost certainly do. Check for *database* and *server* triggers, as per the error message, not triggers on the table `dbo.Attendance`. Look in `sys.triggers` and `sys.server_triggers`. – Jeroen Mostert Jan 22 '19 at 10:06
Yeah, you are right. I found a trigger created by redgate at the sys.server_triggers table. – Ⲁⲅⲅⲉⲗⲟⲥ Jan 22 '19 at 10:32

0 Answers0