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 |
|
HenryFulmer
Posting Yak Master
110 Posts |
 Posted - 2012-08-02 : 17:34:28
|
I have a large file that I'm trying to write to XML and I receive the following error:An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown I have about 130,000 records with 6 elements per record. How can I rectify this? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-02 : 18:00:45
|
| You'll probably have to add RAM to the server. Or modify the code to write XML in smaller batches (5000 rows at a time). It's hard to say without looking at your query. |
 |
|
|
|
|
|
error when writing to XML