SQL Server Developer >> Problem in system tables (SQL Server 2000)
Hi,
When I attempt to update (any column of) a particular table for our
customer, I get the following error:
Could not find new constraint ID 575534446 in sysconstraints, database ID
46, at compile time.
These might be some hints to discover the source of problem:
- The database is under replication
- No error in dbcc checkdb
- Sometimes it seems an objectid has been changed for a table. Because a row
in sysforignkeys refers to an object that does not exist in sysobjects. I'm
wondered that how this can happen!