Is there a limit to the complexity of a query that can be handled by
database mail?
thanks
AdamHi
"Adam Clark" wrote:
> Is there a limit to the complexity of a query that can be handled by
> database mail?
> thanks
> Adam
>
Complexity should not be an issue although if it is a particularly complex
statement I would create a stored procedure. The query parameter is
nvarchar(max) which is 2^31 bytes and probably also be constrained by the
batch size which is 65,536 * Network Packet Size. If you produce large
amounts of output you will be constrained by the MaxFileSize, also you SMTP
relay/server may have limits for total size of the message or attachments.
Is there any particular instance where you have had problems with this?
John
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment