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)

09-29 10:47