Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimoomba
Yak Posting Veteran
90 Posts |
 Posted - 2013-10-30 : 13:35:15
|
| Hi All,My .net application using sql server 2008 r2 worked fine till yesterday. But suddenly stopped working and after checking the event viewer of the windows server i came across the below issue. "XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents.Could not find prepared statement with handle 0.sp_xml_removedocument"Please can any body help me on the same.Thanks,Ramrams |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-30 : 13:46:57
|
| you need to show us query that produced this error.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-30 : 14:07:25
|
| Have you tried using sp_xml_removedocument to release the documents? Or, is the code that is invoking it already doing it? If you don't release the xml documents, the parser that is loaded into memory can take up lot of memory http://technet.microsoft.com/en-us/library/ms190353.aspx |
|
|
|
|
|
|
XML document could not be created because server.