I've been developing more stored procedures lately that use the OpenXML function. I developed these on SQL Server Developer Edition. Normally, I then deploy them to a server running SQL Server Enterprise Edition. I've been doing this for years with no problems.
This time, however, the procs did not work. I kept receiving the following error:
OLE DB provider 'OpenXML' reported an error. The provider did not give any information about the error.
I had deployed the stored procedures to a server running SQL Server Standard Edition. There is a bug that affectes OpenXML on this edition only. The KB article and work around can be found here. I changed the code as the KB suggested, and all worked well.
It figures, doesn't it? The first time I don't use SQL Enterprise, I write code that exposes a SQL Standard-specific bug?