In SQL Server 2000 SP1, this is the error that should occur:
Server: Msg 8929, Level 16, State 1, Line 1 Object ID 1549468469: Errors found in text ID 105872687104 owned by data record identified by RID = (1:359718:4) OBJECTID1 = 1 and OBJECTVALUE1 = 'FUNCLIB_EN ' and OBJECTID2 = 2 and OBJECTVALUE2 = 'EXPL_BOM_SQL ' and OBJECTID3 = 12 and OBJECTVALUE3 = 'FieldF.
Server: Msg 8965, Level 16, State 1, Line 1 Table error: Object ID 1549468469. The text, ntext, or image node at page (1:362025), slot 1, text ID 105872687104 is referenced by page (1:183752), slot 8, but was not seen in the scan. DBCC results for 'PSPCMPROG'. There are 44936 rows in 1893 pages for object 'PSPCMPROG'. CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'PSPCMPROG' (object ID 1549468469). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (xyz.dbo.PSPCMPROG).
NOTE: Running with NOINDEX does not cause the error to occur or terminate the connection.
DBCC CHECKTABLE statistics index ConnectionCheckForData PeekNamedPipe