DanBrother的部落格

How to Increase the Maximum allowed Attachment File Size for email using sp_send_dbmail

Solution:

[Method 1]

(Within SQL Server Management Studio)
Management -> Database Mail -> Configure Database Mail
-> Next -> View or change system parameters -> Maximum File Size (Bytes) : 1000000 => 5000000

[Method 2]
exec msdb.dbo.sysmail_configure_sp 'MaxFileSize','5000000';