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.