BUG: Xp_sendmail with Large Row Results May Cause Error 35909 (169641)

The information in this article applies to:

Microsoft SQL Server 6.5
Microsoft SQL Server 2000 (all editions)

This article was previously published under Q169641

BUG #: 16962 (6.5)
BUG #: 22800 (SHILOH)

SYMPTOMS

Running xp_sendmail can cause SQLMail to get an exception error and stop if all of the following conditions are true:

One of the rows returns more that 2,000 bytes.
The @width parameter is set greater than 2,000
The results are not attached as a file.

WORKAROUND

To work around this problem, do either of the following:

Use the parameter @attach_results=true.

-or-
Do not set @width greater than 2000.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The following is the error that the client process will receive:

Msg 35909, Level 18, State 1
EXCEPTION error encountered in MAPI extended procedures, exception error
code = 0xC0000005

The following are the errors from the SQL Server errorlog:

ods Error : 18009, Severity: 18, State: 1
ods EXCEPTION error encountered in MAPI extended procedures,
exception error code = 0xC0000005
ods Stopped SQL Mail session.

Modification Type:	Minor	Last Reviewed:	2/14/2005
Keywords:	kbBug kbusage KB169641