You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. So what action should you perform to achieve this goal?()
Another SMTP account should be added to the existing Database Mail profile
B. When you send the reports to the manager, you should use the @importance = high parameter.
C. You should change the Account Retry Attempts option of the Database Mail system properties
D. You should configure a new Database Mail profile. The new one will be used for sending the reports to the manager.&e