Based on my previous post on database mail, Khaley writes to ask a question.

"I am using your example for using sp_send_dbmail to send query results as an attachment. However, the query results are too big. "File attachment or query results size exceeds allowable value of 1000000 bytes."

Is there a way to increase the deafult max of the query results?"

With a little research I was able to find the following.  Surprisingly, I couldn't find this in BOL, though.  Here is my reply to Khaley.

That's a good question, one I should blog about.  Yes, you can change these params, but as you might expect BOL is silent on the matter.  If you navigate to Management | Database Mail in object explorer, and right click Database Mail, you can select Configure Database Mail.  Click Next on the opening screen.  On the following screen, you can select View or Change System parameters.  On the next screen you will see an option for Maximum File Size, which you can change by clicking and overwriting. 

Again, thanks for the question.  Good Blog-fodder!

Jon