How to get identity of another table record inside after insert trigger caused by a transaction for current scope and Session?
I have an AFTER INSERT trigger on a table named FileInformation.
The trigger performs two updates on this table.
Spawn transaction from TRIGGER
I’m struggling with triggers and indirect tables I need to mess with.
Spawn transaction from TRIGGER
I’m struggling with triggers and indirect tables I need to mess with.
Old Script Backup Before Run DDL Commands
I have a trigger that follows DDL commands in SQL Server and writes them to the table and now I need to write the script before the alter is made to the table. Is such a thing possible?
Copy structure table with this trigger to new table
I want to copy the structure of a table + trigger to a new table.
I already use this method, but I got some errors.