CODEWITHSUNDEEP
sql-server-2000
user9930
user9930

Reputation: 206

I am getting a "fatal error 7987" error from SQL Server 2000

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.

Upvotes: 1

Views: 1909

Answers (2)

user9930
user9930

Reputation: 206

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.

Upvotes: 2

FlySwat
FlySwat

Reputation: 175703

Bummer dude.

http://support.microsoft.com/kb/828337

Upvotes: 4

Related Questions