Using Azure SQL Server, on a managed instance (i.e. a single server running multiple databases, where the db in question is one of them).
I've created a trigger on
INSERT to table A, that performs an insert of the same data (with some massaging) to table B.
When checking the
sys.triggers table, it seems that the trigger is there and is not disabled. When performing a single manual insert into the table for testing purposes, that trigger works. When looking at the audit logs for that database, that insert is indeed there (i.e. the insert created by the trigger).
When an application is doing the insert, however, the trigger does not fire. I.E. no rows are inserted the table B, and the audit logs are not showing inserts created by the trigger (i.e. the inserts to table B), but are showing the inserts to table A.
Not sure how to debug this further - suggestions for further explorations / solutions are welcome.