SQL_Datada bulunan trigger ve etkilenen tablo isimlerini listeleyen sorgu
<!-- wp:paragraph --> <p>SELECT trigger_name = name, trigger_owner = USER_NAME(uid), table_name = OBJECT_NAME(parent_obj),<br> isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),<br> isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),<br> isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),<br> status = CASE OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') WHEN 1 THEN 'Disabled' ELSE 'Enabled' END<br> FROM sysobjects</p> <!-- /wp:paragraph --> <!-- wp:paragraph --> <p>WHERE type = 'TR'</p> <!-- /wp:paragraph -->
.JPG)
