Hi,

Windows 2003 EE, SQL Server 2000 EE with A/A configuration on Cluster. The
server was dead slow during DML operations & Received series of the bellow
error. After a hour or two the server acted normally. I also observe
"SQLServer" group in cluster failed at a point in event logs.

Event Type:       Warning

Event Source:    BizTalk Server 2004

Event Category: BizTalk Server 2004

Event ID:           5740



Description:

The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
Description="XML document could not be created because server memory is low.
Use sp_xml_removedocument to release XML documents."

<?xml version="1.0" encoding="utf-16" ?><sql_response
xmlns="nameone.nametwo.SQLSend"><?MSSQLError HResult="0x80040e14"
Source="Microsoft OLE DB Provider for SQL Server" Description="XML document
could not be created because server memory is low. Use sp_xml_removedocument
to release XML documents."?></sql_response>".

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Any help to find root cause is highly appreciated.

Thank you

I would check with the BizTalk group. Sounds like there is either an
error in that they are not releasing documents or that you just need
more memory for your server due to the size of the documents being
processed.

Capture FOR XML output in a local string variable?
SQLXMLBulkLoad with VB .Net - No errors but data is not loading
generating XML to validated against the schema
XML files with bad characters
sp_OAMethod and long text return from COM Dll method