Microsoft® SQL Server 2012 Unleashed

Setting Up Database Mail

Setting up profiles and accounts for use with Database Mail is easy to accomplish, thanks mainly to the Database Mail Configuration Wizard, found in the SQL Server Management Studio (SSMS) Object Browser. You can use this wizard both to set up and manage Database Mail. Before using it, you need to switch on the Database Mail feature, which is off by default, in keeping with Microsoft’s secure-by-default approach. Follow these steps to do so.

Configure the Database Mail XPs configuration option by running the following T-SQL code in a new query window (while logged in as sysadmin, of course):

Click here to view code image

use MasterGOsp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'Database Mail XPs', ...