Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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
Add Comment
Please, Sign In to add comment