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

最新推荐文章于 2022-12-05 10:52:48 发布

原创最新推荐文章于 2022-12-05 10:52:48 发布 · 653 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #服务器 #数据库

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

63 篇文章

订阅专栏

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

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.

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