sql - Trigger: Trigger if someone INSERT,UPDATE and DELETE a table -

sql - Trigger: Trigger if someone INSERT,UPDATE and DELETE a table -

i have trigger created log username changeslogtbl if update, delete or insert in tblcurrentrec.

create trigger mytriggerforinsert @username = username <------------------itried place on tblcurrentrec after insert begin insert changeslogtbl values ('username', 'getdate') end go

this works want 1 work on tables within schema. , not limit on insert delete , update well. tried using in , on net , copied , studied different sample no avail. i'm new sql , first time create trigger. hope guys can understand.

thanks.

to cover other dml,

on tblcurrentrec after insert or update or delete

coming schema level coverage, uncertainty can have single trigger tables in schema.triggers should written each table.

if ddl can utilize database triggers

sql sql-server triggers