none
sp_send_dbmail - throws the following error for a 998 KB file. File attachment or query results size exceeds allowable value of 1000000 bytes RRS feed

  • General discussion

  • I know that in order to fix the error "File attachment or query results size exceeds allowable value of 1000000 bytes" we need to configure the Database Mail to increase the attachment size.

    But here my problem is, my file size is 998 KB (so 2 KB less than allowed size). But I still get this error. Note: my file is of type .xlsm.

    It looks like I have no other option but to increase the attachment size but is this how it works? Is it a known bug?
    • Changed type SLAKK Thursday, September 24, 2020 1:58 AM
    Thursday, September 24, 2020 1:58 AM

All replies