When I execute sp_send_dbmail, SQL Server returns error message:
Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 242. At least one of the following parameters must be specified. "@body, @query, @file_attachments, @subject".
I have setup and configured database mail to send email. I use our exchange server to send emails. This is working fine. Here is the test script I am using:
'this is the body of the message.';
I appreciate if somebody could explain why I am getting the error message. How do I fix this? Thanks in advance for your help.
View Complete Post