SHOW:
|
|
- or go back to the newest paste.
| 1 | -- EVENT: ILC_RegenerateReplicationTriggers | |
| 2 | IF NOT EXISTS (SELECT TOP 1 1 FROM Event WHERE EventName = 'ILC_RegenerateReplicationTriggers') | |
| 3 | INSERT INTO Event ([EventName], [AccessAs], [NoteExistsFlag], [RowPointer], [InWorkflow], [IsFrameworkEvent], [IsFrameworkIDOEvent], [IsFrameworkIDOSuspendableEvent], [Description], [EventHasChanged]) | |
| 4 | VALUES ('ILC_RegenerateReplicationTriggers', NULL, 0, '4a4c653c-31e8-4a8e-8905-ee9a5922b817', 0, 0, 0, 0, NULL, 0)
| |
| 5 | ||
| 6 | IF NOT EXISTS (SELECT TOP 1 1 FROM EventHandler WHERE EventName = 'ILC_RegenerateReplicationTriggers' AND RowPointer = '63420546-2D84-40DA-8063-29B46687CB6C') | |
| 7 | INSERT INTO EventHandler (EventName, Sequence, AppliesToObjects, Synchronous, Transactional, IgnoreFailure, Overridable, Active, Obsolete, Suspend, Description, RowPointer) | |
| 8 | VALUES ( | |
| 9 | --EventName | |
| 10 | 'ILC_RegenerateReplicationTriggers' | |
| 11 | --Sequence | |
| 12 | ,1 | |
| 13 | --AppliesToObjects | |
| 14 | ,NULL | |
| 15 | --Synchronous | |
| 16 | ,0 | |
| 17 | --Transactional | |
| 18 | ,0 | |
| 19 | --IgnoreFailure | |
| 20 | ,0 | |
| 21 | --Overridable | |
| 22 | ,1 | |
| 23 | --Active | |
| 24 | ,1 | |
| 25 | --Obsolete | |
| 26 | ,0 | |
| 27 | --Suspend | |
| 28 | ,0 | |
| 29 | --Description | |
| 30 | ,NULL | |
| 31 | --RowPointer | |
| 32 | ,'63420546-2D84-40DA-8063-29B46687CB6C') | |
| 33 | ||
| 34 | IF NOT EXISTS (SELECT TOP 1 1 FROM EventAction WHERE RowPointer = '6C5975EF-F985-4A32-9B74-9C6E0B912FDB') | |
| 35 | INSERT INTO EventAction (EventHandlerRowPointer, Sequence, ActionType, Parameters, Description, RowPointer) | |
| 36 | VALUES ( | |
| 37 | --EventHandlerRowPointer | |
| 38 | '63420546-2D84-40DA-8063-29B46687CB6C' | |
| 39 | --Sequence | |
| 40 | ,10 | |
| 41 | --ActionType | |
| 42 | ,21 | |
| 43 | --Parameters | |
| 44 | ,'IDO("SLReplicationTriggers")
| |
| 45 | METHOD("RegenerateReplicationTriggers")
| |
| 46 | PARMS(E(TableNameVar), E(ServerNameVar), E(DatabaseNameVar), RE(Infobar)) | |
| 47 | RESULT(E(Infobar))' | |
| 48 | --Description | |
| 49 | ,NULL | |
| 50 | --RowPointer | |
| 51 | ,'6C5975EF-F985-4A32-9B74-9C6E0B912FDB') | |
| 52 | ||
| 53 | GO |
