prettsons (10/30/2012)
'Msg 8914, Level 16, State 1, Line 1' error means that the PFS page (see this blog post) has the wrong free-space tracking bits for a text page. In SQL Server 2000, the algorithm to keep track of free space in the PFS pages wasn't perfect so CHECKDB never reported these errors - it would silently fix them. In 2005 we fixed the algorithm (supposedly), so I turned on the reporting of these errors again in CHECKDB.
Not cool to put Paul's words into your paragraph without any indication they're quoted. Makes it look like you were the one who worked on the storage engine team and wrote parts of CheckDB (since that paragraph is written in 1st person).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability