Post reply

Maintenance Plans - Index Rebuild fails with floating point exception

  • July 5, 2007 at 5:46 am

    #717342

    Hello,

     The issue still persist. I have checked everywhere and no information is available, except that this is fixed in SP4. But we are on SP4 and no clue moving forward. Any help be really great,

     

    Thanks

  • July 5, 2007 at 6:14 am

    #717344

    Do you have any computed columns i hope so the problems are still there with computed columns.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 5, 2007 at 7:50 am

    #717377

    Sugesh, Thanks for the reply. No! there are no computed columns.

  • August 7, 2007 at 1:14 pm

    #725262

    Well, the issue is now resolved. For those who are interested

    There are tables with columns defined as FLOAT. 2 such Float columns are part of indices and the rebuild index fails as the floating values lost the precision. DBCC CheckDB with Repair_Fast option helped (suggested by Microsoft Support).

    On safer side, we decided to convert these columns to Money/Decimal (where applicable).

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply