If you plan to take advantage of the ASE select ... for xml feature, then Adaptive Server Enterprise must be properly configured. Enter the following commands:

Verify if ‘select … for xml’ works by entering ‘select * from sysobjects for xml’

Related Tasks

Select for XML