Starting with SQL Server 2008 DBCC PAGE displays INVALID COLUMN VALUE where it used to display the quiet not a number string representation (-1.#QNANs) in previous versions

Until 2005 (included) the function used by DBCC PAGE to print a column’s content, converted the column’s value into the string that was finally printed out, without previously checking whether it was a valid value or not. Beginning with 2008, the validness of the column’s value is checked before converting it into a string to…