https://mssqlfun.com/2017/11/01/db-mail-error-file-attachment-or-query-results-size-exceeds-allowable-value-of-1000000-bytes/
DB Mail error "File attachment or query results size exceeds allowable value of 1000000 bytes"