我收到“致命错误 7987” SQL Server 2000 的错误
尝试从存储过程进行插入时发生错误。 我尝试按照 Jonathan Holland 建议的知识库文章的建议运行 DBCC CHECKDB，结果显示一切正常。
The error happens trying to do an insert from a stored proc. I tried running DBCC CHECKDB as suggested by the kb article that Jonathan Holland suggested and it returned with the all clear.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
真倒霉的家伙。
http://support.microsoft.com/kb/828337
Bummer dude.
http://support.microsoft.com/kb/828337
对受正在调用的存储过程影响的表运行dbcc dbreindex ('tablename')。 这迫使所有页面都被移动，这似乎已经解决了问题。 这表明这是 DBCC CHECKDB 未捕获的页面损坏。
Ran a dbcc dbreindex ('tablename') against the tables that were being affected by the stored procedure that was being called. This forced all of the pages to be moved, which appears to have corrected the problem. This would indicate it was a page corruption that the DBCC CHECKDB didn't catch.