Home Forums SQL Server 2005 Data Corruption Corrupt Database running dbcc checkdb, missing sys.indexes (urgent help needed!) RE: Corrupt Database running dbcc checkdb, missing sys.indexes (urgent help needed!)

  • June 1, 2009 at 6:18 pm

    #1003108

    @rlm - no, because OP didn't do that. He (from the name) changed the compatibility level of the database. You can't change the version of the database. They are not the same.

    See Search Engine Q&A #13: Difference between database version and database compatibility level

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005