Symptom: Sending an attachment using msdb.dbo.sp_send_dbmail results in the following error:
File attachment or query results size exceeds allowable value of 1000000 bytes
How can I increase that value?