|
Posted by Erland Sommarskog on 08/20/07 21:34
Massa Batheli (mngong@gmail.com) writes:
> sql server 2000 sp4 build 2184
>
> runs stats with maintenance plan
> sp_msforeachtable
> stored procedure updating full stats for each table and the results
> are identical
>
> A floating point exception occurred in the user process. Current
> transaction is canceled.
>
> all pointers are to move to latest service pack
> Any pointers on how to avoid this error
It could certainly help if you could give some more detail. Do you get
the error when you run the maintenance plan? Or was running the maintenance
plan an attempt to cure the problem?
If it happens with a query, to try narrow down the query by exluding
columns or rows. Or even tables.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|