March 16, 2009 at 8:56 am
Hi,
I am not sure where to post. But I am sending here.
I have an SSIS package which uses a stored procedure sp_email_send that sends the mail.
But now I got a problem in this..... This SP uses cdo objects to send the mails. I am getting the error as
Not enough storage is available to complete this operation.
Can any one suggest any solutions?
Thank You
March 17, 2009 at 12:25 am
You may find this article on SSC useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 17, 2009 at 2:49 am
Adiga (3/17/2009)
You may find this article on SSC useful.
Thanks for your reply pradeep. I checked that link of Hot fixes before posting this question to you. But mine is not DTS package and is a SSIS package.
It is ran fine from last one month and suddenly this problem came.
Moreover, the same problem has come in last month and we extended the disk space to 1 GB. It worked well and again I am getting the error after one month.
Thank You
March 17, 2009 at 2:53 am
It had also mentioned about checking the "Database growth" settings. Please check the same on the Database in question and the tempdb.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 17, 2009 at 8:00 am
Adiga (3/17/2009)
It had also mentioned about checking the "Database growth" settings. Please check the same on the Database in question and the tempdb.
Thanks Pradeep. Will check and update on this.
Thank You
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply