How to fix system tables integrity errors? DBCC CHECKCATALOG  points
that exists objects (in sys.columns) without depend views. In SQL 2000 I can
edit direct sysobject table. How delete orphaned objects in SQL 2005? Only
way is copy data to new database?

I wouldn't think editing sysobjects is a real good idea, unless you're very
(very) sure.

However, since CHECKCATALOG is part of CHECKDB, I would assume you would
used CHECKDB to repair any problems.

Show quoteHide quote

Cannot register server (LOCAL)
Timeouts after periods of inactivity in server
sqlmaint.exe issue
BCP truncation error on few tables?
service pack on windows server prior install sql server 2005 standard
EXISTS Performance Problem
Cannot get proxy account to work.
Temp table solve the performance issue?
Stored procedure sp_sqlagent_get_perf_counters uses too much cpu t
join SmallDateTime column very slow