RG_SQLLighthouse_DDLTriggerRedGate and In Memory Tables

jboyer

More a comment and FYI.
I tried to move some tables from Disk to Memory in a database that was monitored by DLM. (I forgot I set DLM for that server.) I was receiving an error:
Database and server triggers on DDL statements CREATE, ALTER and DROP are not supported with memory optimized tables. (Microsoft SQL Server, Error: 12332)
Thanks to a response from Erland Sommarskog an MVP in the MS SQL Forum, I found RG_SQLLighthouse_DDLTrigger installed on the server.
Uninstalled the Trigger... table migrated as planned.

This brings a question on DLM and SQL Server In-Memory Technologies support. Can I restart the trigger with no side effects?

way0utwest

You can, but if you perform other In-Memory OLTP DDL, you'll get the error again. This is a bit of an effect of the way DLM Dashboard uses DDL triggers.