title: How do I increase the maximum allowed attachment size for email sent using msdb.dbo.sp_send_dbmail in Microsoft SQL Server 2005/2008
body: <p>Symptom: 
  Sending an attachment using msdb.dbo.sp_send_dbmail results in the following error:</p>
  
  <p>File attachment or query results size exceeds allowable value of 1000000 bytes</p>
  
  <p>How can I increase that value?</p>