Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML Buffer length

Status
Not open for further replies.
ashridharan

ashridharan

Technical User
Aug 19, 2001
26
0
0
US
Has anyone faced a situation of the XML string, returned from a query fired on SQL server (using 'for xml auto'), being truncated ???
On my ASP page from where the query is being fired, the xml returned is being automatically truncated halfway.
Is there any setting to avoid this ??
ashish
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
75
grnzbra
grnzbra
ahmedsa2018
  • Locked
  • Question
How to change STRING_AGG to stuff xml to split feature value by pip?
Replies
0
Views
50
ahmedsa2018
ahmedsa2018
ElEye
  • Locked
  • Question
Parse XML via SQL query 1
Replies
1
Views
43
gmmastros
gmmastros
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
68
Andrzejek
Andrzejek
PPettitDN
  • Locked
  • Question
How to add attributes to the root element when generating XML?
Replies
1
Views
108
PPettitDN
PPettitDN

Part and Inventory Search

Sponsor

Back
Top