Post reply

DBMail Attachement Problem

  • June 9, 2009 at 4:23 am

    #134854

    Hi All

    I have a SP that sends mail as a attahement using DBMail, when i run the SQL i get the error as follows

    Msg 22050, Level 16, State 1, Line 0

    File attachment or query results size exceeds allowable value of 1000000 bytes.

    One posting said that i need a patch from MS ( on our forum) , when i tried to update the patch it said this patch is for SP1 and you have SP2 on your machine so this cant be installed,

    I have included @query_result_no_padding =1, option as well, still getting this error

    Have any one faced this problem earlier, please let me know what i can do to get over this error

    Thanks in advance for all your helps

  • June 9, 2009 at 5:12 am

    #1006577

    Hi,

    The default size for attachment in DBMail is 1000000 Bytes. Please increase the default size if you want to attach a file bigger than this. Go to Management>>Database mail>>Configure Database Mail>>View or Change System Parameters--Increase the Maximum File Size (Bytes) here to whatever you think your file size can be.

  • June 9, 2009 at 5:29 am

    #1006591

    Thats Great , Thanks mate

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

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