USP_REVENUE_SYNC_BEFORESYNC
Used by the sync process to turn off the insert trigger before revenue records are processed
Definition
Copy
create procedure dbo.USP_REVENUE_SYNC_BEFORESYNC
as
if exists (select object_id from sys.triggers where name = 'TR_REVENUE_MARKASCONSTITUENT')
disable trigger dbo.TR_REVENUE_MARKASCONSTITUENT on dbo.REVENUE;