Configuring SQL Database Mail
Here is a sample script for configuring database mail in the event you want to automate your SQL installs.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
EXEC sys.sp_configure 'Advanced options', 1; RECONFIGURE EXEC sys.sp_configure; USE msdb GO --Step1: Varifying the new profile SELECT * FROM sysmail_profile --Step2: Verifying accounts SELECT * FROM sysmail_account --Step3: To check the accounts of a profile SELECT * FROM sysmail_profileaccount WHERE profile_id = 3 --Step4: To display mail server details SELECT * FROM sysmail_server select * FROM sysmail_allitems |
…
Read More