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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-23 : 08:21:31
|
| Chris writes "Hey,Is there any way to export XML from SQL Server to a text file using an XML Query. The amount of data is large, a few hundred megabytes at least. BCP makes line breaks mid XML tag. All ADO/ scripting methodologies buffer the entire file to memory; maxing out the machine. Don't be stumped like Microsoft was.-Chris Donnan--www.pch.com-PS; We wrote a .Net .exe using various streams, but it seems a bit overkill to basically export a text document, which they fully support queries for." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Large XML Export from SQL 2000 