Post reply

XML in 2000

  • June 7, 2007 at 2:33 pm

    #76722

    My XML result set in SQL Server 2000 gets truncated.  How can I prevent this?

    As an example, this simple query in SQL Server 2005 works great:

    USE Northwind

    GO

    SELECT ProductName, QuantityPerUnit, UnitPrice

    FROM dbo.Products

    FOR XML AUTO, ELEMENTS

    But gets truncated in 2000.  Please help.

    David

  • June 13, 2007 at 4:50 am

    #712553

    David,

    Hi, I've just run the query through Query Analyzer and using Studio Express and not found a problem. What are you doing with the results of the queries that you are using?

    This may help to clarify the problem...


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply