I found another db that we inherited and no one had a CHECKDB scheduled. I ran it on this db and found this error:

Server: Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 2. The text, ntext, or image node at page (1:87), slot 7, text ID 95630196736 is not referenced.

CHECKDB found 0 allocation errors and 1 consistency errors in database 'PHASE2'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PHASE2 ).

SELECT name FROM sysobjects WHERE id = 2

sysindexes

(1 row(s) affected)

So it appears that the consistency error is in the sysindexes table? How serious of a problem is this and will the repair_allow_data-loss only effect the sysindexes table and not the application db data.