Problem in system tables (SQL Server 2000)  
Author Message
isaacvargas





PostPosted: Top

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!

Any help would be greatly appreciated.
Leila

SQL Server66