Hi all,
we're running xml-query against sql server 7 with IIS and XML EXPLICIT mode. When we try to run the same query against sql server 2000 through the same IIS the result is a bad formed xml.
To obtain a well formed xml with sql server 2000 we have to add the 'tag' column into 'order by' clause while in sql server 7 it's not necessary.
We have several applications running against the sql7 whithout the tag inside the order by and we have to migrate them to sql2000. Is there a way to configure the sql2000 so we don't have to modify all them?
Thanks on advance to everybody
we're running xml-query against sql server 7 with IIS and XML EXPLICIT mode. When we try to run the same query against sql server 2000 through the same IIS the result is a bad formed xml.
To obtain a well formed xml with sql server 2000 we have to add the 'tag' column into 'order by' clause while in sql server 7 it's not necessary.
We have several applications running against the sql7 whithout the tag inside the order by and we have to migrate them to sql2000. Is there a way to configure the sql2000 so we don't have to modify all them?
Thanks on advance to everybody