On a W2000 sql2000 (SP3a) server we got Error 3628: [Microsoft][ODBC SQL Server Driver][SQL Server]A floating point exception occurred in the user process. Current transaction is canceled.
This occurs during the optimization job, as well in the application (queries)
MS advices to install SP4. We did install SP4, but the problem resists !
I tried several things without succes:
- restoring the db
- truncate the (problem) table (after this the optim run good), refill (import) the table (the problem is back)
- dbcc checkdb (no errors) and dbcc checkallock (no errors)
- install the db on another server
It is a very urgent problem so a QUICK HELP would be very welcome !!!