You can run DBCC CHECKDB with REPAIR_FAST option. This will fix your current database. Then you can use the detach and attach metod to copy database.

If table is owned by dbo then this query returns results as expected in SQL Server 2000.

select hire_date, * from employee order by hire_date desc

I am encountering with the same problem when running the stored procedue sp_helpdb.I have changed the db owner to 'sa', but this did not help.I still get the same error.

Server:...