درباره Trigger

[Accidentboy]

سلام

از کجا می شه دید که یه Trigger فعال یا نه ؟

[AminSobati]

create table t1(
c1 int)
go

create trigger trg1 on t1 after insert as
select null
go

select objectpropertyex (object_id('trg1'),'ExecIsTriggerDisabled')
go

alter table t1
disable trigger trg1
go

select objectpropertyex (object_id('trg1'),'ExecIsTriggerDisabled')