BUG: Xp_sendmail with Large Query Results Causes Error 35909

Q166014

The information in this article applies to:
BUG #: 16743 (6.5)
BUG #: 220800 (SHILOH)

SYMPTOMS

Running xp_sendmail may cause SQLMail to get an exception error and stop if the amount of results in bytes of the query is greater than 8 megabytes (MB) and the results are not attached as a file.


WORKAROUND

To work around this problem, always use the @attach_results=true parameter with xp_sendmail when the results are very large.


STATUS

Microsoft has confirmed this to be 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 : kbusage kbSQLServ650bug kbDSupport kbSQLServ2000 kbSQLServ2000bug
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ650 kbSQLServ2000Search kbSQLServ2000


Last Reviewed: October 27, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.