UpdateStats

  • 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??

  • Which SQL Server Version and Service Pack did the error occur on?

  • 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)

  • 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