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