How can we help you today? How can we help you today?

RG_SQLLighthouse_DDLTriggerRedGate and In Memory Tables

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?
jboyer
0

Comments

1 comment

Sort by
  • 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.
    way0utwest
    0

Add comment

Please sign in to leave a comment.