Posted by Erland Sommarskog on 06/13/06 22:06

(maidonical@gmail.com) writes:
> I am trying to run "select * from <table> where <columnname> = 0.0" in
> query analyzer
><columnname> is a float
>
> I get the following error:
> Server: Msg 3628, Level 16, State 1, Line 1
> A floating point exception occurred in the user process. Current
> transaction is canceled.
>
> I get the same error when I use the float <columnname> through an
> application
>
> I have tried upgrading to SP4, without any luck - still get the error
> message.

Check you SQL Server error log, to see if it could be the problem
described in http://support.microsoft.com/kb/892840. Note that this
fix is not in SP4.


--
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

• Next in forum: Stored Procedure Issue - Problem with temporary tables
• Prev in forum: Re: Performance issue
• Thread view: Re: A floating point exception occurred in the user process - Msg 3628

[Reply to this message]