Hi. Thank you for taking the time. I have problems with a specific sql server, I get ole 800 range errors. I am an installation and support technician, low to perhaps mid level sql skill. Attached is an example of a random error we get. This was sent to me today by the server administrator. I support a Delphi front end app, with sql back end. Hardware Description: Linux Host machine, with 20 GB ram available. On top of that, virtually, sits the Windows Server 2008, that carries the sql installation. The dbase is 60 GB in size. (I believe the hardware is the issue, if you want to know more, let me know. 130 users log on!) Problem description: OLE 800 range errors, all over. I resolve them by increasing the size under files in the management studio. It doesn't always work. Sometimes restarting the sql server service helps.
You will have to run DBCC CHECKDB() to identify where you have problems. It's possible that they're only in non-clustered indexes which can be easily dropped and recreated. Otherwise, you may be facing fundamental corruption issues. The best solution there is to go to a good backup of the database. You may be seeing disk or I/O issues, so you should also run fundamental system checks to see where the problem may be occurring.