Advertisement
bluebunny72

ILC_RegenerateViewsToMasterSite event

Feb 18th, 2015
331
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.65 KB | None | 0 0
  1. -- EVENT: ILC_RegenerateViewsToMasterSite
  2. IF NOT EXISTS (SELECT TOP 1 1 FROM Event WHERE EventName = 'ILC_RegenerateViewsToMasterSite')
  3.     INSERT INTO Event ([EventName], [AccessAs], [NoteExistsFlag], [RowPointer], [InWorkflow], [IsFrameworkEvent], [IsFrameworkIDOEvent], [IsFrameworkIDOSuspendableEvent], [Description], [EventHasChanged])
  4.     VALUES ('ILC_RegenerateViewsToMasterSite', NULL, 0, '42168ef3-93cf-4895-91be-7fcd7e200c55', 0, 0, 0, 0, NULL, 0)
  5.    
  6. IF NOT EXISTS (SELECT TOP 1 1 FROM EventHandler WHERE EventName = 'ILC_RegenerateViewsToMasterSite' AND RowPointer = 'FEBD40B5-B98F-4C6F-8B5E-F2A048BAEE94')
  7.     INSERT INTO EventHandler (EventName, Sequence, AppliesToObjects, Synchronous, Transactional, IgnoreFailure, Overridable, Active, Obsolete, Suspend, Description, RowPointer)
  8.     VALUES (
  9.     --EventName
  10.      'ILC_RegenerateViewsToMasterSite'
  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.     ,'FEBD40B5-B98F-4C6F-8B5E-F2A048BAEE94')
  33.  
  34. IF NOT EXISTS (SELECT TOP 1 1 FROM EventAction WHERE RowPointer = 'BA915745-0699-4887-9A79-EAEEA84A4B64')
  35.     INSERT INTO EventAction (EventHandlerRowPointer, Sequence, ActionType, Parameters, Description, RowPointer)
  36.     VALUES (
  37.     --EventHandlerRowPointer
  38.      'FEBD40B5-B98F-4C6F-8B5E-F2A048BAEE94'
  39.     --Sequence
  40.     ,10
  41.     --ActionType
  42.     ,21
  43.     --Parameters
  44.     ,'IDO("SLReplicationTriggers")
  45. METHOD("ReCreateUsingSiteViewSp")
  46. PARMS(E(IntraNet_Name), RE(Infobar))
  47. RESULT(E(Infobar))'
  48.     --Description
  49.     ,NULL
  50.     --RowPointer
  51.     ,'BA915745-0699-4887-9A79-EAEEA84A4B64')
  52.  
  53. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement