Im using sql2005 and in a simple query in the mngt studio return the error:
Msg 21, Level 24, State 1, Line 1Warning: Fatal error 824 occurred at May 16 2007 11:07AM. Note the error and time, and contact your system administrator.
Someone know what is this error and how to fix it ?
You got trouble in River City. According to MS:
The 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication of actual damage and frequently indicates data corruption caused by a faulty I/O subsystem component.
Time to get kicking with DBCC. I hope you've been testing your backups on a regular basis.
I have seen it before.
Right click on My Computer icon, select manage, Open the Event Viewer Tree, Select Application and check there for the time of the error to see what happened to your system. If nothing there then do the same on the SQL Server Machine is connected remotely.
We walk in the dark places no others will enterWe stand on the bridge and no one may pass