1

I have two tables: table 1 is disk based storage and table 2 is in memory storage. I create a DML trigger on table 2 and in that trigger, I insert a record into table 1. Will it be possible?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Balamurugan.Santhanaraj
  • 156
  • 1
  • 2
  • 8

1 Answers1

0

You can't, it's not possible in the same in-memory transaction using mvcc isolation access a disk-based table through the trigger.

For workaround this you could saving to a stage table memory-based inside the trigger and insert or update to table 1 from stage table using update-join between a memory-based-disk and table-based-disk although it cames with some admin to manage and control but works.

DDL Tiggers still doesn't work even SQL 2017.

Alexandre Araujo
  • 1
  • 1