• That is corrupt beyond the point of being able to identify objects. You've got fatal metadata corruption and allocation page corruption.

    You're going to be very lucky if you get much at all out of that.

    Go through the tables one by one (select name from sysobjects where xtype='U'), see if you can generate the script, see if you can select any of the data. I suspect a good number of objects will fail. It will take quite some time.

    May be easier just to go back to the last good backup and accept that everything since is lost.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass