This article transferred from: http://blog.csdn.net/miqi770/article/details/48708199
SELECTT.name asTableName, Tr.name asTriggername, Case when 1=ObjectProperty(Tr.id,'execistriggerdisabled') Then 'Disabled' ELSE 'Enabled' ENDStatus fromsysobjects TINNER JOINsysobjects TR ont.id=Tr.parent_objWHERE(T.xtype= 'U' ORT.xtype= 'V') and(Tr.xtype= 'TR') ORDER byT.name, Tr.name
ALTER TABLE TABLENAME enable trigger triggername ALTER TABLE TableName enable trigger triggername View all triggers in the current library
This article transferred from: http://www.cnblogs.com/davidhou/p/5846914.html
--View all the triggers in the current library:
SELECT * from Sysobjects WHERE xtype = ' TR '
--View all the triggers in the current library and the tables that correspond to them:
SELECT Tb2.name as tablename,tb1.name as Triggername from Sysobjects Tb1 joins Sysobjects TB2 on Tb1.parent_obj=tb2.id wher E tb1.type= ' TR '
--Displays the definition of the trigger:
EXEC sp_helptext ' trigger name '
--View information about the trigger:
EXEC sp_help ' trigger name '
--View the types of triggers in the table:
EXEC sp_helptrigger ' table name '
[GO] SQL Server view trigger disabled/enabled situation