SQL_Trigger-Tablo listesi(Hangi trigger hangi tabloda)
<blockquote> <p>SELECT trigger_name = name, table_name = OBJECT_NAME(parent_obj),</p> <p> isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),</p> <p> isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),</p> <p> isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),</p> <p> status = CASE OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') WHEN 1 THEN 'Disabled' ELSE 'Enabled' END</p> <p>FROM sysobjects</p> <p>WHERE type = 'TR'<br /> AND NAME NOT LIKE '%LG_%'and</p> </blockquote>
0 Yorum