Microsoft KB Archive/169641

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:34, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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