Microsoft KB Archive/166014

{|
 * width="100%"|

BUG: Xp_sendmail with Large Query Results Causes Error 35909

 * }

Q166014

-

The information in this article applies to:


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

-

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