Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need Help!!! Fatal Error 823

Author  Topic 

AuGusts0LitAirE
Starting Member

3 Posts

Posted - 2008-07-26 : 09:38:34
Just new to this whole SQL thing...
Need help w/ this:

SQL Server Message 21

Warning: Fatal Error 823 occurred at July 26 2008 7:34 PM


Debugging info; dbresults,SqlCompile - executeDbproc 2
Cursor(81) pscreencustom1 '4010000','%','%','110061',500
Optional info pscreencustom1 '4010000','%','%','110061',500



Thanks...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-07-26 : 11:08:22
Short answer: Run for the hills.

Long answer: 823 is a physical disk error. It indicated that a page that SQL requested from disk could not be read. It is a very severe error message and it indicates that you have a major problem with that DB or with the server in total.

Do you have a recent backup?

Check the event log on that server, look in system and application. See if there are any disk-related errors.
Run a checkDB on the DB. DBCC CheckDB('< Database name >) WITH NO_INFOMSGS

Right now, I would suggest you stop all DB-related activity on the server until you get a better idea of what's wrong.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

AuGusts0LitAirE
Starting Member

3 Posts

Posted - 2008-07-27 : 21:38:33
Thanks for the answer....

Anyway we've had an "isass.exe" error before we encountered this. So we were running in "Safe Mode",then we realized that we have this error. Has it something to do with any or both of those(isass.exe & Safe Mode)?

Need your help badly... And many thanks...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-27 : 22:50:48
Take look at those links:

http://www.file.net/process/isass.exe.html
http://www.liutilities.com/products/wintaskspro/processlibrary/isass/
http://www.askmehelpdesk.com/desktops/isass-exe-system-error-34553.html
Go to Top of Page

AuGusts0LitAirE
Starting Member

3 Posts

Posted - 2008-07-28 : 01:54:47
Hi....
Thanks for the links... But we're done with the isass.exe thing. Already had the unit, in this case the server, reformatted. Just want to know if it has something to do with the Fatal 823 error...
Thanks...
quote:
Originally posted by rmiao

Take look at those links:

http://www.file.net/process/isass.exe.html
http://www.liutilities.com/products/wintaskspro/processlibrary/isass/
http://www.askmehelpdesk.com/desktops/isass-exe-system-error-34553.html

Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-07-28 : 05:57:27
Maybe, maybe not. 823, as I mentioned before, is indicative of a hardware error. Run checkDB, check your drives.

Do you have a recent backup?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -