FIX: sp_processmail Will Only Process One Query per Execution

 Last reviewed: April 8, 1997
Article ID: Q152416
The information in this article applies to:
  • Microsoft SQL Server version 6.5

SYMPTOMS

The stored procedure sp_processmail will only process one query sent via e- mail each time it is run if SQLMail is running with Microsoft Exchange Client software.

CAUSE

The execution of xp_deletemail is breaking the loop in sp_processmail, which is used to process all of the messages.

WORKAROUND

If you are scheduling sp_processmail as a task, you have the following options:

  1. Change the task to run every minute. Note that this will work as long as there is not more than one query per minute sent to SQL Server via e-mail.
2. Make multiple tasks to run sp_processmail that run every minute. This 
   provides a workaround for option 1 above.
3. Change the sp_processmail stored procedure not to delete the mail it 
   responds to by commenting the xp_deletemail call.
4. Change the sp_processmail stored procedure to not run in a loop but to 
   instead do several iterations.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: xp_sendmail xp_deletemail
Keywords : kbbug6.50
Version : 6.5
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.