In my production system, a query that used to work is now failing after some recent upgrades to the schema. The statement:
SELECT * FROM [production].[item] WHERE [ItemID] = 921
is not returning all the columns. There are several sparse columns defined in the table, but they are not returned from the query, and instead a lump of XML is returned.
What could be causing this?