Error 602 when attaching Databases

Posted on 2006-05-30
Last Modified: 2008-01-09
Greetings Experts,

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.

Question by:malc77
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    are u trying to attach the sql server 2005 db in sql server 2000. If so it is not possible, unless the compatablility level is 80

    Author Comment

    thanks for your response....I detached using 2005 and trying to reattach with 2005....
    LVL 68

    Expert Comment

    >> From what I have gathered all servie packs were reinstalled as well. <<

    The service pack and hot fix / patch levels should be *exactly* the same.
    LVL 28

    Expert Comment

    Should have taken backup for your database

    How are you reattaching the databases?

    Author Comment

    OK....I had to remove 2k and reinstall 05.  For some reason 05 was reading the 2k instance.

    Thanks for your help.....


    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now