So it came up that several of our devs are writing their TSQL entirely in code using ADO.NET and submitting their queries that way.<BR><BR>Initially the idea was sprocs for all inserts, updates, etc..

I am using TSQL to extract data and drop it to XML. The problem is that the system consuming this XML file must have the xmlns="blah" portion appearing first, otherwise it fails. How the heck can I ...