GilaMonster (7/15/2013)
You've got database corruption.The table name will be printed as part of the CheckDB output. Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Sorry i forgot to mention i am using SQL 2000. so sys.objects is not valid. Yes i am querying the correct DB