Viewing 2 posts - 1 through 2 (of 2 total)
Adiga (8/1/2010)EXEC msdb.dbo.sp_send_dbmail@recipients=N'myemail@mydomain.com',@body='Message Body',@subject ='Message Subject automated test',@profile_name ='mailtest',@file_attachments ='C:\FileAttachment.txt';What is the output after executing the above query? Do you see any error messages?
Adiga (8/1/2010)
EXEC msdb.dbo.sp_send_dbmail@recipients=N'myemail@mydomain.com',@body='Message Body',@subject ='Message Subject automated test',@profile_name ='mailtest',@file_attachments ='C:\FileAttachment.txt';
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'myemail@mydomain.com',
@body='Message Body',
@subject ='Message Subject automated test',
@profile_name ='mailtest',
@file_attachments ='C:\FileAttachment.txt';
What is the output after executing the above query? Do you see any error messages?
The query executes successfully and results in...
August 2, 2010 at 12:02 am
#1200853
Yes, the same result occurs with or without the attachment.
August 1, 2010 at 9:51 pm
#1200833