USP_REVENUE_SYNC_AFTERSYNC

Used by the sync process to re-enable the insert trigger on the revenue table after all revenue records are processed

Definition

Copy


create procedure dbo.USP_REVENUE_SYNC_AFTERSYNC

as

    if exists (select object_id from sys.triggers where name = 'TR_REVENUE_MARKASCONSTITUENT'
        enable trigger dbo.TR_REVENUE_MARKASCONSTITUENT on dbo.REVENUE;