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', 0
RECONFIGURE
GO
DBCC CheckCatalog (<database name>)
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