The following SQL Script enables you to search the database for a trigger. This script can be very useful in troubleshooting performance problems or issues updating the database through Sage System Administrator.

If using Sage 200 Manufacturing the following triggers would exist by default:

• tr_WorksOrderTrackingUpdatePipelineData
• tr_WoUpdateBulkIssueItems
• tr_JobOperationsUpdatePipelineData
• tr_JobsUpdateEstStatus
• tr_JobsUpdateWoStatus

To search for triggers run the following SQL script:

SELECT trigger_name = sysobjects.name, trigger_owner = USER_NAME(sysobjects.uid),
table_schema = s.name, 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'),
[disabled] = OBJECTPROPERTY(id, 'ExecIsTriggerDisabled')
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
WHERE sysobjects.type = 'TR'