Microsoft KB Archive/169641

= BUG: Xp_sendmail with Large Row Results May Cause Error 35909 =

Article ID: 169641

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: mapi mail sp_processmail 18009

Keywords: kbbug kbusage KB169641

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.