|
3>
4> SELECT OBJECT_NAME(parent_id) Table_or_ViewNM,
5> name TriggerNM, is_instead_of_trigger, is_disabled
6> FROM sys.triggers
7> WHERE parent_class_desc = 'OBJECT_OR_COLUMN'
8> ORDER BY OBJECT_NAME(parent_id), name
9> GO
Table_or_ViewNM
TriggerNM
is_instead_of_trigger is_disabled
------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
----------------- --------------------- -----------
1>
|