• brickpack (7/12/2013)


    I'm also having a hard time appending this to the top of the file:

    <?xml version="1.0" encoding="ISO-8859-1"?>

    Any suggestions...?

    I usually hard-code any header info and append it manually to the XML file. It won't usually render it properly in the SSMS window. You can use a browser or I use Programmer's Notepad++ (a free dowload) which handles every format possible. Once you have confirmed the XML is valid, and appended any header info and declarations, then it's usually converted back to NVARCHAR anyway prior to being posted via an HTTP client or whatever.