The final step in setting up Database Mail is to ask SQL Server to send a test email. To do this, right-click the
Database Mail folder in the Object Browser and then click the Send Test E-mail menu option.
If the test fails, click Troubleshoot, and SMSS opens the “Troubleshooting Database Mail” Books Online topic, which provides a solid set of troubleshooting steps to get you started.
If the mail is sent by SQL Server and successfully received in your client software’s inbox, you can proceed to the next section to learn how to use the
sp_send_dbmail stored procedure to send email from T-SQL. Otherwise, look for more troubleshooting help in the “Related Views and Procedures” section of this chapter.