SQL 2000? Typically means that someone's been messing around with the system tables, making direct updates without understanding the consequences of what they're doing.
Please run the following and post the full and complete results.
DBCC CheckDB (<Database Name>) WITH No_INFOMSGS, ALL_ERRORMSGS
DBCC CheckCatalog (<Database Name>) WITH No_INFOMSGS
SQL Server MVP