Post reply

Problems with sp_send_dbmail

  • August 3, 2009 at 9:47 am

    #208903

    I've been using email on my SQL 2005 box for a long time now...first time that I am trying to attach results from a query though. This exact code works fine on my SQL 2000 box. Syntax is still good. As soon as I add the @query option I get the following message:

    Msg 22050, Level 16, State 1, Line 0

    Memory allocation failure.

    To rule out results size problems, for testing, I am simply returning 'SELECT 1'

    Any ideas?

  • August 3, 2009 at 8:08 pm

    #1034030

    Not sure what the problem was. Restarted SQL services this evening and the memory allocation error has vanished. sp_send_dbmail can send attachments after the service restart.

    It's always bitter sweet when restarting services (or the server) fixes your problem.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply