Desperate, Need Help w/error 80040e31

I am hoping someone may be able to shed some light on this issue. I have, literally spent countless hours now trying to determine what causes my SQL sever to hang when my optimization job runs every Tuesday morning. Optimization job will begin, and website becomes inaccessable. the error returned when an attempt to navigate to the site is: Microsoft OLE DB provider for SQL Server error 80040e31, Programs/cart2001/ecom/shop_trns.asp line 48. If I put up a splash page, this does not happen, but apparently when asp requests are made to the sql database while the optimization job is running, my entire system hangs, and a reboot is necessary. I have tried Microsoft, Chat Forums, etc. Can anyone help shed some light on this issue? I would be every grateful!!!! Thanks.

Have you checked the logs? Check out the application event logs.

I have viewed the error logs, and they consistently show no explanation of the reason. Has anyone seen this before, and if so, any causes? Many thanks.

I'm guessing all tables are locked during the optimization and so you're getting a timeout. Shouldn't lock your system up, but it is Windows, after all. If this is the issue, I don't know of a way around it short of scheduling the optimization for a very low-activity time and maybe sticking a spash page up during the optimization.

Many, Many thanks for your feedback and help! It is greatly appreciated.

Hello,

Did you try to apply the Service Pack 4 if you have SQL Server 2000?