![]() ![]() You can also use sysmail_help_configure_sp procedure without any arguments to return all configuration options. In this example I passed MaxFileSize as an argument to narrow the results to just the configuration option that I’m interested in. | MaxFileSize | 1000000 | Default maximum file size | You can use the sysmail_help_configure_sp stored procedure in the msdb database to check the attachment file size limit. If you haven’t yet received an error, you might not know what the limit is. Here’s the error you’ll receive if you try to send an attachment that’s larger than the allowable attachment file size: Msg 22051, Level 16, State 1, Line 0įile attachment or query results size exceeds allowable value of 1000000 bytes. If you need to send attachments that are larger than the attachment limit, you’ll need to increase that limit.įortunately, increasing the allowed attachment file size can be done with a single line of T-SQL code. When you use Database Mail to send emails with attachments, you’ll need to ensure that the attachment file size is within the allowable attachment file size. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |