Arithmetic overflow after upgrading to 7.0

[Vadim Levinzon]

We have a stored procedure that was not changed and was running with no
problem for years on 6.5
And now after upgrading 7.0 (+ SP1) it constantly generates and error:
"Arithmetic overflow error for type varchar, value = 99.824980."
Even though every single line of stored procedure insert correct data
anyway.
The error line points to a very innocent line of code
insert #t values('</td><td align=centerd bgcolor="#339999"><font
face=arial,helvetica size=-1>Effective</td>')
but it gets inserted.
Anybody else run into something like that ?

[Michael]

I wonder if it has to do with the use of the double-quotes to delimit the
color in the constant. If the SPs were recompiled with SET QUOTED_IDENTIFIER
ON. Try changing the double-quotes to chr(34).

-Mike

[Gert Drapers]

I ran this against 7.0 SP2 and it works, does this fail on your machine ?
If not can you please provide a repro including the table structure and
settings.

create table #t(c1 varchar(8000))
go
set quoted_identifier on
insert #t values('</td><td align=centerd bgcolor="#339999"><font
face=arial,helvetica size=-1>Effective</td>')
set quoted_identifier off
insert #t values('</td><td align=centerd bgcolor="#339999"><font
face=arial,helvetica size=-1>Effective</td>')
go

-GertD