I have a stored procedure, that uses FORXML AUTO to reutrn an XML document.
When I call it from SQLCMD, it results in a hexadecimal value (0x....) instead of an XML text.
When I used to call it from OSQL, it resulted in a correct XML text.
When I call it from SQL Mgmt Studi or Query Analyser, the reult is also correct, an XML text.
The way I call SQLCMD is:
sqlcmd -E -S"SQLCLU01\INST01" -d"SFA" -Q"exec ReportGetDataAsXML 6760910"
The result is:
View Complete Post