I have a server running coexisting instances of SQL2k and SQL2005. Recently, databses were dettached and the software reinstalled. From what I have gathered all servie packs were reinstalled as well. The databases(10) themselves were detached using SQLSvr2005, none will reattached.
Error '602' cannot find row in sysindexes for database ID 9, object id 1, index id 1. Run DBCC checktable on sysindexes.
select @@version = 'Microsoft Sql Server 2000 - 8.00.2039'
This seems strange because I am using QA in 2005.
Also SQL Server Integration Services will not Start regardless of configuration
Your help is greatly appreciated.