Is there a limit to the complexity of a query that can be handled by
database mail?
thanks
Adam
Hi
"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
Showing posts with label complexity. Show all posts
Showing posts with label complexity. Show all posts
Monday, March 26, 2012
more database mail
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
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
more database mail
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
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:
Posts (Atom)