How to check if triggers enabled?
[69] HXHALODB1.dmo_govcorp.1> alter table formula disabletrigger formula_u;
Disabling trigger 'formula_u'.
The way to check
update trigger:
[71] HXHALODB1.dmo_govcorp.1> select sysstat2 & 4194304 from sysobjects where name = 'formula'
[71] HXHALODB1.dmo_govcorp.2> go
|
|-----------
| 4194304
(1 row affected)
insert trigger:
[72] HXHALODB1.dmo_govcorp.1> select sysstat2 & 1048576 from sysobjects where name = 'formula'
[72] HXHALODB1.dmo_govcorp.2> go
|
|-----------
| 0
(1 row affected)
Delete trigger:
[73] HXHALODB1.dmo_govcorp.1> select sysstat2 & 2097152 from sysobjects where name = 'formula'
[73] HXHALODB1.dmo_govcorp.2> go
|
|-----------
| 0
(1 row affected)