Warning: Fatal error 7987
Posted on 2006-04-10
We are seeing this problem in our application:
Warning: Fatal error 7987 occurred at Apr 10 2006 9:18AM猠楡⹤䄠牰汩椠⁳敤楳湧瑡摥愠⁳慎楴湯. Note the error and time, and contact your system administrator.
And upon checking the SQL logs we are seeing everytime a specific simple query is run:
A possible database consistency problem has been detected on database 'allscoopdb'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'allscoopdb'..
We had this problem once last week, and a reboot fixed it. The error is coming up everytime we run a specific sql query against the allscoopdb database. We have been running this query for over a year with no problems.
I've run the DBCC CHECKDB and it has returned no errors. Do you think there could be some kind of hardware problem? Or what else can I do to figure out what the problem is?
We are running MSSQL 2k on a big box. It's a quad box with 16 gigs of RAM with a SAN device. We are using managed hosting at RackSpace.