error with OPENXML

  • I have a stored procedure which uses UNION on Three or 4 SELECT queries. Each select query uses openXML once. Whenever i run this stored proceure on my SqlServer 2000 i get the following error:

    "OLE DB provider 'OpenXML' reported an error. The provider did not give any information about the error."

    The surprising thing is that this stored procedure runs fine on a different Sql Server. The Databases on both the servers are identical.

  • This was removed by the editor as SPAM

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

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