Since SQLServer leaves unparsed ':' character in queries, it's possible (almost!) to produce the query output recognizable for further BTS processing. For example:

select 'urn:EverestUpdateDocument' as 'xmlns:ns1',
updateDate as 'ns1:updateDate',
updateProcessed as 'ns1:updateProcessed'
from Updates
for xml auto

produces

<updates xmlns:ns1="urn:EverestUpdateDocument" ns1:updateDate="2004-08-18T00:00:00" ns1:updateProcessed="0">
</updates>
<updates xmlns:ns1="urn:EverestUpdateDocument" ns1:updateDate="2004-08-1900:00:00" ns1:updateProcessed="0"></updates>

Unfortunatelly, however, there is no way to put in the same namespace the element holding the attributes In the examle below, the element "Updates' belongs to default namespace.

SQLServer Adapter makes unpossible to put in the (distinct) namespace the root element as well.