View Single Post

   
  #4 (permalink)  
Old 03-01-2008, 02:40 PM
Erland Sommarskog
 
Posts: n/a
Default Re: A floating point exception occurred in the user process

Massa Batheli (mngong@gmail.com) writes:
> Erland Thanks for your response as usual
> The maintenance plan was intended to troubleshoot the process .


I don't think floating-point errors are due to poor statistics or
fragmented indexes. You may be able to get rid of the error that
way if you get a different plan, that does not provoke the error.
But in that case, you never know when it comes back and bite you
again.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Reply With Quote