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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Obtaining XML data

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-01-13 : 07:59:58
Shane writes "To whom it may concern

Im trying to obtain xml data. USing "select top 2 *
from sta_voiceroute_MONTHLY_SUMMARY
for xml auto, elements"
However my data is being cut off at a certain amount of characters thru query analyser. I have tried a data pump but that doesnt work. How can I get all of my data and what is the best method.

Regards



Shane"
   

- Advertisement -