用DBCC checkcatalog(数据库)检测出结构异常

最新推荐文章于 2025-06-16 12:09:41 发布

蝈蝈(GuoGuo)

最新推荐文章于 2025-06-16 12:09:41 发布

阅读量626

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库SQL server 文章标签： java 服务器数据库

本文链接：https://blog.youkuaiyun.com/delphigbg/article/details/127604742

数据库SQL server 专栏收录该内容

61 篇文章

订阅专栏

博客展示了数据库检测出的错误信息，如多个表对象在 'SYSOBJECTS' 和 'SYSCOMMENTS' 中不匹配。解决办法是将其他数据库中对应的表和存储过程复制过来，因为当前数据库缺少这些过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 69575286 (object 'dt_displayoaerror') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 133575514 (object 'dt_checkoutobject') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 165575628 (object 'dt_removefromsourcecontrol') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 233767890 (object 'PBF_SalerRoom') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 281768061 (object 'PBF_SalerGather') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 457768688 (object 'PAF_PTackle') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Msg 2513, Level 16, State 5, Line 1
Table error: Object ID 781245838 (object 'TFU_CustSumAmountBad') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

以上是检测出的错误信息，后在其它的数据库中将对应的表，存储过程复制过来就可以。他是没有这些过程。