SQL Server 2005 sp_send_dbmail appears internal error at Formatrowset (Reason:not enough storage was available to complete this O Peration)

Source: Internet
Author: User
Tags microsoft sql server 2005

Case Environment:

Operating system: Windows 2003 SE 32bit (SP2)

Database version: Microsoft SQL Server 2005-9.00.5069.00 (Intel X86)

22 2012 16:01:52

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790:service Pack 2)

Case Analysis:

As shown below, when you send a message using the following SQL statement, you encounter a very strange error message: Not enough storage are available to complete this operation

EXEC ' [email protected] ',
' It's only Test ' NULL ' text ',
'---',
' SELECT * from MESDB.dbo.MES_DAILY_CLOSING_LOG ';

MSG 22050, Level A, State 1, line 22

Error formatting query, probably invalid parameters

MSG 14661, Level A, State 1, Procedure sp_send_dbmail, line 517

Query execution failed:Sqlcmd:Error:Internal Error at Getdatarowset (Reason:not enough storage are available to Complet e this operation).

Sqlcmd:Error:Internal Error at Formatrowset (Reason:not enough storage was available to complete this operation).

Error Although prompted storage not engough, in fact, this error and storage has no relationship, the table mes_daily_closing_log inside there are three fields nvarchar (MAX), take the following two ways to temporarily solve the problem.

1: If the three nvarchar (MAX) fields are excluded from @query, the message is sent normally without any errors.

2: If the field is converted in @query, such as cast (mail_receips as NVARCHAR (4000)), then the mail will be sent normally.

This issue does not occur under SQL Server 2008, SQL Server 2012, and in addition to the SQL Server 2005 (9.00.5000.00) version. Only this server will be error, later in this Sp_help_jobsteplog fails when run as a @query of the sp_send_dbmail of the text , after restarting the database service, There will be no such problem. Waiting for a week to wait until a suitable time to restart the server, verify that after the restart, the error has disappeared. There is very little information about this error on the web, and serious suspicion is that a bug has been triggered.

Resources:

Https://social.msdn.microsoft.com/Forums/en-US/0882f984-58f4-4a2a-8d0c-5f2c1e3cc853/msdbdbospsenddbmail-error? Forum=transactsql

Http://dba.stackexchange.com/questions/3591/sp-help-jobsteplog-fails-when-run-as-a-query-of-sp-send-dbmail

SQL Server 2005 sp_send_dbmail appears internal error at Formatrowset (Reason:not enough storage was available to complete this O Peration)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.