We are using SQL Server 2000 + SP4 on Windows 2003 Ent Server + SP2.
I have a job scheduled on weekly basis unser the Database Maintenance Plan. During the execution of this job I get the following error:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628: [Microsoft][ODBC SQL Server Driver][SQL Server]A floating point exception occurred in the user process. Current transaction is canceled. [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I have noticed that this error occurs when system tried to rebuild the index on a prticular table. This table has only one float column.
I have tried to get the MIN (=-1) and MAX (=100) values from this table which seems quite in the range of the float datatype.
I also tried to run "select * from MyTable where MyCol=0.0" and get the error message "A floating point exception occurred in the user process. Current transaction is canceled."
I did the research on web but did not find anything helpful. Microsoft recommends to install SP4 which is already installed.
There were 4 curroupt records in the table. I updated these record with the correct values for the column having float data type and it resolved the problem.
I had to export the whole table in ACCESS and did trial/error and able to isolate the 4 records (out of 300000 records)having problem.
rmiao: after updating the 4 records, I was able to rebuild the index. Thanks for your help.
A floating point exception occurred in the user...
Posted - 07/01/2007 : 11:18:37
