You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01, and two Microsoft Exchange Server 2003 mail servers named Certkiller -EX01 and Certkiller -EX02. The Simple Mail Transfer Protocol (SMTP) is enabled on both mail servers.
Certkiller -DB01hosts a database named CK_Sales that is used to store sales related data for the company. The CK_Sales database contains a table named Inventory. The manager of the Purchasing department has requested a database report containing a list of the 20 most popular products and the amount of stock the company has for each of the top 20 products. You have produced the report. You attempt to send the report by e-mail using the sp_send_dbmail procedure but receive a failed return code. You verify that the mail servers are online and that the SMTP service is running on them.
You to need to send the report by e-mail from Certkiller -DB01.
What should you do?
A.
Enable Database Mail for the database instance.
B.
Install a Messaging Application Programming Interface (MAPI) client on Certkiller -DB01.
C.
Install Microsoft Office Outlook on Certkiller -DB01.
D.
Run the DatabaseMail90.exe utility on Certkiller -DB01.
Explanation:
You need to enable Database Mail before you can use the sp_send_dbmail procedure. Database Mail is not enabled by default but can be enabled by using the Database Mail Configuration Wizard, the SQL Server Surface Area Configuration tool, or sp_configure.
Incorrect Answers:
B, C: There is no need to install a mail client such as Microsoft Office Outlook or any other mail client on the database servers. SQL Server 2005 uses the Database Mail feature to send e-mail messages but this feature is not enabled by default.
D: The DatabaseMail90.exe utility is the utility that the sp_send_dbmail procedure uses to send the e-mail message. However, this utility will not run if Database Mail is not enabled.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: sp_send_dbmail