Options
RG_SQLLighthouse_DDLTriggerRedGate and In Memory Tables
jboyer
Posts: 11 Bronze 2
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?
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?
Tagged:
Answers