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.
Database Mail XPs configuration option by running the following T-SQL code in a new query window (while logged in as
sysadmin, of course):
use MasterGOsp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'Database Mail XPs', ...