Advertisement
bluebunny72

UET Impact Script

Feb 3rd, 2017
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. --impact schema
  2. DECLARE @PCommit ListYesNoType
  3.     ,@PRollback ListYesNoType
  4.     ,@PImpact ListYesNoType
  5.     ,@RedoViews ListYesNoType
  6.     ,@Infobar InfobarType
  7.  
  8. SET @PCommit = 1
  9. SET @PRollback = 0
  10. SET @PImpact = 1
  11. SET @RedoViews = 0
  12. SET @Infobar = NULL
  13.  
  14. EXEC UETImpactWrapperSp @PCommit
  15.     ,@PRollback
  16.     ,@PImpact
  17.     ,@RedoViews OUTPUT
  18.     ,@Infobar OUTPUT
  19.  
  20. IF @RedoViews = 1
  21. BEGIN
  22.     DECLARE @Ibar InfobarType
  23.  
  24.     EXEC ReCreateUsingCurrentSiteViewSp @Ibar
  25. END
  26. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement