I created a Server Level Trigger to capture events at my sql server. Is there a way to capture an event when someone disables this trigger?
I know limiting access to sysadmin is simple solution but we have some situations that is not possible so I am wondering if there is a way to capture event or send notification when a Server level trigger is disabled or enabled?
Create trigger [ServerAuditTrigger]
on all server
with execute as 'sa'
for DDL_EVENTS
as
begin
insert into table
select eventdata()
end
go