SQL Server Performance

SQL Server 2000 - SQLXML 4

Discussion in 'SQL Server 2008 General DBA Questions' started by fjlf1983, Jan 26, 2010.

  1. fjlf1983 New Member

    Hi everyone!
    I´d like to know if it´s possible to use SQLXML 4 from SQL Server 2000 or I need to install SQLXML 3.
    Thanks in advance.
  2. Luis Martin Moderator

    Welcome to the forums!
    Migration Issues for Client-Side FOR XML

    Dueto changes in the execution engine, SQL Server 2005 may returndifferent values in the metadata for a base table than would bereturned if the FOR XML query was executed under SQL Server 2000. Incases where this occurs, client-side formatting of the FOR XML queryresults will have differing output depending on whether the same queryis run against SQL Server 2000 or SQL Server 2005.
    If a FOR XML query is executed client-side using SQLXML 3.0 over an xmldata type column, the data in the results will come back as a fullyentitized string. In SQLXML 4.0, if the SQL Native Client (SQLNCLI) isspecified as the provider, the data will be returned as XML.

Share This Page