57. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 11/9/2018 12:16:39 PM Eastern Standard Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

57.1 Files compared

# Location File Last Modified
1 RAMS-2.3.0.zip\RAMS-2.3.0\SQL Setup_DatabaseMail_Profile.sql Tue May 15 15:44:42 2018 UTC
2 RAMS-2.3.0.zip\RAMS-2.3.0\SQL Setup_DatabaseMail_Profile.sql Fri Nov 9 15:00:22 2018 UTC

57.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 6 108
Changed 5 12
Inserted 0 0
Removed 0 0

57.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

57.4 Active regular expressions

No regular expressions were active.

57.5 Comparison detail

  1   use master  
  2   go 
  3   sp_configu re 'show a dvanced op tions',1 
  4   go 
  5   reconfigur e with ove rride 
  6   go 
  7   sp_configu re 'Databa se Mail XP s',1 
  8   --go 
  9   --sp_confi gure 'SQL  Mail XPs',
  10   go 
  11   reconfigur
  12   go 
  13    
  14   ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------- 
  15   -- BEGIN M ail Settin gs  DNS . URL          
  16   ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------- 
  17   IF NOT EXI STS(SELECT  * FROM ms db.dbo.sys mail_profi le WHERE   name = 'RA MSReminder s')  
  18     BEGIN 
  19         --CREATE P rofile [ DNS . URL         
  20       EXECUT E msdb.dbo .sysmail_a dd_profile _sp 
  21         @pro file_name  = 'RAMSRem inders', 
  22         @des cription   = 'RAMSRem inder Noti fication';  
  23     END --IF  EXISTS pr ofile 
  24      
  25     IF NOT E XISTS(SELE CT * FROM  msdb.dbo.s ysmail_acc ount WHERE   name = ' RAMSRemind ers') 
  26     BEGIN 
  27         --CREATE A ccount [ DNS . URL         
  28       EXECUT E msdb.dbo .sysmail_a dd_account _sp 
  29       @accou nt_name             =  'RAMSRemi nders', 
  30       @email _address            =  'donotrep ly@RAMSRem inders.com ', 
  31       @displ ay_name             =  'RAMSRemi nders', 
  32       @reply to_address          =  'donotrep ly@RAMSRem inders.com ', 
  33         @descripti on                = ' DNS . URL          ', 
  34         @mailserve r_name           = ' DNS . URL          ', 
  35       @mails erver_type          =  'SMTP', 
  36       @port                      =  '25', 
  37       @usern ame                 =   NULL , 
  38       @passw ord                 =   NULL ,  
  39       @use_d efault_cre dentials =   0 , 
  40       @enabl e_ssl               =   0 ; 
  41     END --IF  EXISTS  a ccount 
  42      
  43   IF NOT EXI STS(SELECT  * 
  44                  FROM m sdb.dbo.sy smail_prof ileaccount  pa 
  45                    INNE R JOIN msd b.dbo.sysm ail_profil e p ON pa. profile_id  = p.profi le_id 
  46                    INNE R JOIN msd b.dbo.sysm ail_accoun t a ON pa. account_id  = a.accou nt_id   
  47                  WHERE  p.name = ' RAMSRemind ers' 
  48                    AND  a.name = ' RAMSRemind ers')  
  49     BEGIN 
  50         -- Associa te Account  [ DNS . URL          ] to Profi le [ DNS . URL        
  51       EXECUT E msdb.dbo .sysmail_a dd_profile account_sp  
  52         @pro file_name  = 'RAMSRem inders', 
  53         @acc ount_name  = 'RAMSRem inders', 
  54         @seq uence_numb er = 3 ; 
  55  
  56           EX ECUTE msdb .dbo.sysma il_add_pri ncipalprof ile_sp
  57       @profi le_name =  'RAMSRemin ders',
  58       @princ ipal_name  = 'public' ,
  59       @is_de fault = 0  ;
  60     END