January 21, 2013 at 8:35 am
Hi,
I'm getting this error message on the UpdateStasAllUserDB job that ran happily for over 1 Year.
Job view history ....sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Maintenance reporting text file says:
[12] Database userdbname: Updating Query Processor Statistics (sampling 30 percent of the data)...
[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.
Any ideas? drop and recreating maintenance plan will work??
January 21, 2013 at 9:24 am
Which SQL Server Version and Service Pack did the error occur on?
January 21, 2013 at 9:27 am
Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
January 21, 2013 at 9:40 am
It looks like there was a bug prior to 2000 SP4 that could cause this, but post-SP4, table or index corruption would be more likely.
Start by running a CheckDB and see if that flags any errors.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply