TR_EXCHANGECALENDARSYNC_UPDATED

Definition

Copy


                    CREATE trigger [dbo].[TR_EXCHANGECALENDARSYNC_UPDATED] on [dbo].[EXCHANGECALENDARSYNC] after update not for replication
                    as begin
                        --if update(APPUSERIDSETREGISTERID) or update(SPECIFICAPPUSERID) or update(INTERACTIONFILTERCODE) or update(SPECIFICAPPUSERID) or update(APPLYTOCODE) or update(CREATEITEMOPTIONCODE) or update(CREATEDEFAULTREMINDER) or update(DEFAULTREMINDERAMOUNT) 

                        if update(APPUSERIDSETREGISTERID) or update(SPECIFICAPPUSERID) or update(INCLUDEPENDINGINTERACTIONS) or update(INCLUDEPROSPECTPLANSTEPS) or update(INCLUDEPENDINGSTEWARDSHIPSTEPS) or update(SPECIFICAPPUSERID) or update(APPLYTOCODE) or update(CREATEITEMOPTIONCODE) or update(CREATEDEFAULTREMINDER) or update(DEFAULTREMINDERAMOUNT)                         
                            update ecs set ecs.LASTRUNON = null, ecs.CHANGEDBYID = i.CHANGEDBYID from dbo.EXCHANGECALENDARSYNC ecs inner join inserted i on ecs.ID = i.ID 

                    end