the inserted and deleted tables are created manually

triggers can be disabled using alter table

a single trigger can be created for both insert and delete

@@sqlstatus contains the number of rows affected