<div>
Higher in the code, @idata should have been prepared with <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-xml-preparedocument-transact-sql?view=sql-server-2017" rel="ugc">sp_xml_preparedocument</a>. Ensure that whatever sp_xml_prepareddocument is consuming hasn't changed...
</div>


Higher in the code, @idata should have been prepared with sp_xml_preparedocument [https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-xml-preparedocument-transact-sql?view=sql-server-2017]. Ensure that whatever sp_xml_prepareddocument is consuming hasn't changed...

<div>
<div class="content wysiwyg-content">
I have a SQL Server query that extracts XML from an XML feed. &nbsp;It uses openxml like so:<br />
<br />
select top 1 updated from openxml( @idata, '//content:feed', 2 ) with ( updated varchar(31) 'content:updated' )<br />
<br />
I have the same database on two different servers. &nbsp;Same code. &nbsp;It works perfectly fine on one server and it has been working perfectly fine on another... then all of a sudden it stopped working on the 19th I believe. &nbsp; There are no errors... it just returns NULL instead of the XML value containing the feed update date.<br />
<br />
Any idea why it stopped working? &nbsp;Is there something that may have got stuck or disabled somehow on the problem server in sql server 2008? &nbsp;I'm sure it's some type of configuration issue. &nbsp;I don't really know the ins and outs of the OpenXML statement. &nbsp;I know there are other alternatives but I'm just trying to get it back running before considering a major code change. &nbsp;Thanks!
</div>
</div>


I have a SQL Server query that extracts XML from an XML feed.  It uses openxml like so:

select top 1 updated from openxml( @idata, '//content:feed', 2 ) with ( updated varchar(31) 'content:updated' )

I have the same database on two different servers.  Same code.  It works perfectly fine on one server and it has been working perfectly fine on another... then all of a sudden it stopped working on the 19th I believe.   There are no errors... it just returns NULL instead of the XML value containing the feed update date.

Any idea why it stopped working?  Is there something that may have got stuck or disabled somehow on the problem server in sql server 2008?  I'm sure it's some type of configuration issue.  I don't really know the ins and outs of the OpenXML statement.  I know there are other alternatives but I'm just trying to get it back running before considering a major code change.  Thanks!

OpenXML SQL Server statement suddenly stopped working

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.