MS SQL XML - XML stored proc problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

XML stored proc problem

nysqldba

2006-01-09, 10:14 am

One of my users has a problem with a stored procedure that creates XML.

The stored procedure contains a single SELECT statement that goes something like this:

SELECT
....
FROM
table1
UNION ALL
SELECT
...
FROM
table2
UNION ALL
....
FOR XML EXPLICIT

This statement returns the following error when run in the stored procedure but returns the xml output when run stand alone.

SqlDumpExceptionHand
ler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIO
LATION. SQL Server is terminating this process.

What could be the problem?
Thanks,
Ed

Sponsored Links