A floating point exception occurred in the user process. Current transaction is canceled.

[chris.higginson@gmail.com]

Hi,
I'm running SQL Server Version 8.00.194 on Windows 2000.

I am am running this query:
select TOP 2000
TheoVolImplied
from OptionTrades
where ReutersSymbol = 'IBM.N'
and TheoVolImplied > 0.0

TheoVolImplied is of type float, precision 15, length 8.

When I run this query I get this error:
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current
transaction is canceled.

If I run this query:
select TOP 2000
TheoVolImplied
from OptionTrades
where TheoVolImplied > 0.0

It works fine with no problems.

If I run this query:select TOP 2000
TheoVolImplied
from OptionTrades
where ReutersSymbol = 'IBM.N'

It works fine with no problems.

Anyone have any ideas about what might be wrong?

[Erland Sommarskog]

Re: A floating point exception occurred in the user process. Current transaction is canceled.

[posted and mailed, please reply in news]

(chris.higginso n@gmail.com) writes:[color=blue]
> I'm running SQL Server Version 8.00.194 on Windows 2000.[/color]

That's the RTM version, and Sp4 for SQL 2000 was released just a few
days ago, see http://www.microsoft.com/sql/downloads/2000/sp4.asp.

I can't say for sure, but there are good odds that what you see are bugs
which have been fixed.

It's also wotrh mentioning that if you run an earlier version than SP3,
you do not have protection against the Slammer worm.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Gang He [MSFT]]

Re: A floating point exception occurred in the user process. Current transaction is canceled.

This is likely a server interanl bug. Can you try the SQL2K SP4 to see
whether it is fixed there already? If not, please contact Microsoft
Customer Support Service. Also you can send me a repro('r' me), I can help
to check it out.

--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.
<chris.higginso n@gmail.com> wrote in message
news:1116440974 .872006.213580@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> Hi,
> I'm running SQL Server Version 8.00.194 on Windows 2000.
>
> I am am running this query:
> select TOP 2000
> TheoVolImplied
> from OptionTrades
> where ReutersSymbol = 'IBM.N'
> and TheoVolImplied > 0.0
>
> TheoVolImplied is of type float, precision 15, length 8.
>
> When I run this query I get this error:
> Server: Msg 3628, Level 16, State 1, Line 1
> A floating point exception occurred in the user process. Current
> transaction is canceled.
>
> If I run this query:
> select TOP 2000
> TheoVolImplied
> from OptionTrades
> where TheoVolImplied > 0.0
>
> It works fine with no problems.
>
> If I run this query:select TOP 2000
> TheoVolImplied
> from OptionTrades
> where ReutersSymbol = 'IBM.N'
>
> It works fine with no problems.
>
> Anyone have any ideas about what might be wrong?
>[/color]