• GilaMonster (1/17/2013)


    mitzyturbo (1/17/2013)


    We still have the 2000 instance of this db, is there anyway we can pinpoint the change at that level, identify and migrate the fix?

    Oh yes, absolutely and very easy in SQL 2000. If you can fix there and re-upgrade the DB, that's by far the easiest.

    SELECT * FROM syscolumns WHERE objectid = 528161077

    That should return 21 rows. If so...

    EXEC sp_configure 'allow updates', 1

    RECONFIGURE

    DELETE FROM syscolumns WHERE objectid = 528161077

    GO

    EXEC sp_configure 'allow updates', 1

    RECONFIGURE

    GO

    DBCC CheckCatalog (<database name>)

    I am guessing that the second sp_configure should be to set it back to 0 to prevent updates?