Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- sysobjects.name AS trigger_name
- ,USER_NAME(sysobjects.uid) AS trigger_owner
- ,s.name AS table_schema
- ,OBJECT_NAME(parent_obj) AS table_name
- ,OBJECTPROPERTY( sysobjects.id, 'ExecIsUpdateTrigger') AS isupdate
- ,OBJECTPROPERTY( sysobjects.id, 'ExecIsDeleteTrigger') AS isdelete
- ,OBJECTPROPERTY( sysobjects.id, 'ExecIsInsertTrigger') AS isinsert
- ,OBJECTPROPERTY( sysobjects.id, 'ExecIsAfterTrigger') AS isafter
- ,OBJECTPROPERTY( sysobjects.id, 'ExecIsInsteadOfTrigger') AS isinsteadof
- ,OBJECTPROPERTY(sysobjects.id, 'ExecIsTriggerDisabled') AS [disabled]
- ,*
- FROM sysobjects
- INNER JOIN sysusers
- ON sysobjects.uid = sysusers.uid
- INNER JOIN sys.tables t
- ON sysobjects.parent_obj = t.object_id
- INNER JOIN sys.schemas s
- ON t.schema_id = s.schema_id
- JOIN dbo.sysComments ON
- sysobjects.ID = dbo.sysComments.id
- WHERE sysobjects.type = 'TR'
- and
- OBJECTPROPERTY(sysobjects.id, 'ExecIsTriggerDisabled') = 0
- and OBJECT_NAME(parent_obj) like 'Zam%'
- and text like '%FRS_ID%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement