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?