Microsoft KB Archive/308604

= PRB: SQLMail Is Not Supported When You Run the Server in Fiber Mode =

Article ID: 308604

Article Last Modified on 10/9/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q308604





SYMPTOMS
SQLMail may stop responding (hang) when the server that you are using is run in Fiber mode. Fiber mode is when you set the lightweight pooling option ON by using the sp_configure stored procedure.

When SQLMail stops responding:  You cannot invoke any new SQLMail functions such as:

 xp_sendmail xp_readmail xp_findnextmsg xp_deletemail

-and-

 Existing SQLMail connections do not work.</li></ul>

From a SQL Server perspective, generally all new non-SQLMail connections and existing non-SQLMail connections function normally. However, there may be rare situations in which SQL Server may also become unresponsive.

<div class="moreinformation_section">

MORE INFORMATION
Both MAPI and SQLMail make use of &quot;critical section&quot; synchronization objects in their implementation. The implementation details of both MAPI and SQLMail may encounter situations where the initial thread is scheduled out after entering a critical section and later may get rescheduled to a different thread. The rescheduling to a different thread causes the program to stop responding. According to the Microsoft Windows 32 documentation, a thread that enters the critical section must be the same one to exit the critical section or the critical section is not released. If the critical section is not released, the program may stop responding. Due to these architectural limitations of SQLMail and MAPI, Microsoft does not recommend or support SQLMail when the server is running in Fiber mode.

<div class="references_section">