• This is a SQL 2005 server?

    What's the type of syskeys?

    SELECT type_desc from sys.objects where name = 'syskeys'

    Some other important questions.

    Has checkDB been running successfully up until now?

    Is this DB an upgraded DB from SQL 2000?

    Are there any messages in the error log about direct updates to the system catalog? Would appear right after SQL brings the DB online.

    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