Veritabanında bulunan tüm Triger lerin listesi

USE  deneme
GO

Select trigger_name = name, trigger_owner = USER_NAME(uid), table_name =
OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'),
isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'), isinsert =
OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter =
OBJECTPROPERTY( id, 'ExecIsAfterTrigger'), isinsteadof =
OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'), status = CASE
OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') WHEN 1 THEN 'Disabled'
ELSE 'Enabled' END FROM sysobjects WHERE type = 'TR'
order by name