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.