|
|
Posted by Massa Batheli on 08/21/07 14:24
Erland Thanks for your response as usual
The maintenance plan was intended to troubleshoot the process .
Mike
On Aug 20, 5:34 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> MassaBatheli (mng...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|