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.
# | 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 |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 6 | 108 |
Changed | 5 | 12 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
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 |
No regular expressions were active.
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', 0 | |
10 | go | |
11 | reconfigur e | |
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 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.