Pasted

-- EVENT: ILC_RegenerateReplicationTriggers
IF NOT EXISTS (SELECT TOP 1 1 FROM Event WHERE EventName = 'ILC_RegenerateReplicationTriggers') 
    INSERT INTO Event ([EventName], [AccessAs], [NoteExistsFlag], [RowPointer], [InWorkflow], [IsFrameworkEvent], [IsFrameworkIDOEvent], [IsFrameworkIDOSuspendableEvent], [Description], [EventHasChanged])
    VALUES ('ILC_RegenerateReplicationTriggers', NULL, 0, '4a4c653c-31e8-4a8e-8905-ee9a5922b817', 0, 0, 0, 0, NULL, 0)
    
IF NOT EXISTS (SELECT TOP 1 1 FROM EventHandler WHERE EventName = 'ILC_RegenerateReplicationTriggers' AND RowPointer = '63420546-2D84-40DA-8063-29B46687CB6C') 
    INSERT INTO EventHandler (EventName, Sequence, AppliesToObjects, Synchronous, Transactional, IgnoreFailure, Overridable, Active, Obsolete, Suspend, Description, RowPointer)
    VALUES (
    --EventName
     'ILC_RegenerateReplicationTriggers'
    --Sequence
    ,1
    --AppliesToObjects
    ,NULL
    --Synchronous
    ,0
    --Transactional
    ,0
    --IgnoreFailure
    ,0
    --Overridable
    ,1
    --Active
    ,1
    --Obsolete
    ,0
    --Suspend
    ,0
    --Description
    ,NULL
    --RowPointer
    ,'63420546-2D84-40DA-8063-29B46687CB6C')
 
IF NOT EXISTS (SELECT TOP 1 1 FROM EventAction WHERE RowPointer = '6C5975EF-F985-4A32-9B74-9C6E0B912FDB')
    INSERT INTO EventAction (EventHandlerRowPointer, Sequence, ActionType, Parameters, Description, RowPointer)
    VALUES (
    --EventHandlerRowPointer
     '63420546-2D84-40DA-8063-29B46687CB6C'
    --Sequence
    ,10
    --ActionType
    ,21
    --Parameters
    ,'IDO("SLReplicationTriggers")
METHOD("RegenerateReplicationTriggers")
PARMS(E(TableNameVar), E(ServerNameVar), E(DatabaseNameVar), RE(Infobar))
RESULT(E(Infobar))'
    --Description
    ,NULL
    --RowPointer
    ,'6C5975EF-F985-4A32-9B74-9C6E0B912FDB')
 
GO