October 18, 2011 at 4:38 am
Using below code to send mail with attachment.
EXEC sp_send_cdosysmail
@From ='Test@abc.com' ,
@To = 'Test@abc.com' ,
@Subject ='Test Mail',
@Body ='Test Body,
@attachments ='C:\Test.xls'
I get the below error. But I get the attachment in mail. So should i have to concerned about the below error?
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
October 18, 2011 at 4:47 am
If you are using the example for cdosysmail that MS provided, you may need to make some changes. Here is a thread that appears to be down the same avenue you are facing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 18, 2011 at 6:00 am
Do we have any other way.. to fix this? The link has code which has BCC etc. which is not needed. A basic mail parameters are fine.
October 18, 2011 at 8:46 am
Do you have access to your cdosysmail proc to make the change that is necessary in the output?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply