Floating point exception

21 Jul 2005 8:33 PM

Britney

Hi guys,
what is the problem? how can I fix it?

DBCC INDEXDEFRAG (0, table1, 2)

Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current transaction
is canceled.

21 Jul 2005 8:37 PM

Aaron Bertrand [SQL Server MVP]

With all the problems you've been having, my suggestion would be to create
your database over again from scratch.

Show quote

"Britney" <britneychen_2***@yahoo.com> wrote in message
news:%23S7$KOjjFHA.2444@tk2msftngp13.phx.gbl...
> Hi guys,
> what is the problem? how can I fix it?
>
>
> DBCC INDEXDEFRAG (0, table1, 2)
>
>
> Server: Msg 3628, Level 16, State 1, Line 1
> A floating point exception occurred in the user process. Current
> transaction
> is canceled.
>
>

21 Jul 2005 8:43 PM

David Gugick

Britney wrote:

> Hi guys,
> what is the problem? how can I fix it?
>
>
> DBCC INDEXDEFRAG (0, table1, 2)
>
>
> Server: Msg 3628, Level 16, State 1, Line 1
> A floating point exception occurred in the user process. Current
> transaction is canceled.

What version of SQL Server are you using?

--
David Gugick
Quest Software
www.imceda.com
www.quest.com

21 Jul 2005 9:08 PM

Britney

..818

I think it's because corrupted data.

Show quote

"David Gugick" <david.gugick-nospam@quest.com> wrote in message
news:eKHiWTjjFHA.3656@TK2MSFTNGP09.phx.gbl...
> Britney wrote:
> > Hi guys,
> > what is the problem? how can I fix it?
> >
> >
> > DBCC INDEXDEFRAG (0, table1, 2)
> >
> >
> > Server: Msg 3628, Level 16, State 1, Line 1
> > A floating point exception occurred in the user process. Current
> > transaction is canceled.
>
> What version of SQL Server are you using?
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com