Post reply

is there a max size for the attachment size in msdb.dbo.sp_send_dbmail

  • May 4, 2010 at 12:55 pm

    #224105

    trying to attach an excel file thats 4 megs and i get the below error

    Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes.

    Is this attachment size changable?

  • May 4, 2010 at 1:02 pm

    #1162046

    Here is a link to the article and how to change it.

    http://msdn.microsoft.com/en-us/library/ms186321.aspx

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • May 4, 2010 at 1:02 pm

    #1162047

    I found this searching SSC

    -- Cory

  • May 4, 2010 at 1:38 pm

    #1162065

    thanks guys. that worked.

    Here is what i used.

    EXECUTE msdb.dbo.sysmail_configure_sp

    'MaxFileSize', '1000000000'

  • August 31, 2011 at 9:43 am

    #1375563

    I'm running into this same problem. I changed the default to be 9 GB since my exchange environment has a 10GB limit. I am still getting the same error. Is there another step? It is like the change was not accepted. Here is what I changed and the error from the email. I’m running SQL Server 2008 SP2 CU4 (10.0.4285)

    Exec sysmail_help_configure_sp

    EXECUTE msdb.dbo.sysmail_configure_sp

    'MaxFileSize', '9663676416' ;

    Exec sysmail_help_configure_sp

    MaxFileSize9663676416Default maximum file size

    Error

    Msg 22051, Sev 16, State 1: File attachment or query results size exceeds allowable value of 100000 bytes. [SQLSTATE 42000]

  • August 31, 2011 at 9:58 am

    #1375571

    Well perhaps it just can go that high. I changed it to 2 MB which is sufficient for my issue and it worked.

    Exec sysmail_help_configure_sp

    EXECUTE msdb.dbo.sysmail_configure_sp

    'MaxFileSize', '2097152' ;

    Exec sysmail_help_configure_sp

Viewing 6 posts - 1 through 5 (of 5 total)

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