Home Forums SQL Server 2005 Data Corruption corrupt index (nonclustered primary key) after 2005 upgrade RE: corrupt index (nonclustered primary key) after 2005 upgrade

  • Not sure what could be happening here, I've pinged a corruption expert to get some advice.

    Just one question first, pick a table that has this problem and run the following queries please and post the results.

    DECLARE @tblName sysname

    SET @tblName = 'LargeTable'

    SELECT name, type_desc FROM sys.indexes WHERE object_id = OBJECT_ID(@tblName)

    SELECT name from sys.key_constraints where parent_object_id = OBJECT_ID(@tblName)

    Does ALTER INDEX ... REBUILD give the same error?

    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