When I run the following query in SQL Server 2000, it works fine but when I
run into SQL Server 20005, it gave me following error.

Msg 8115, Level 16, State 7, Line 1

Arithmetic overflow error converting numeric to data type numeric.

Any idea, how can I resolve it, I migrate my database into SQL Server 2005
and this type of errors are comming.

Please help...

What command is that?

--
Andrew J. Kelly SQL MVP

"Rogers" <naissani (AT) hotmail (DOT) com> wrote

What patch level on each installation?

Also, check your sp_configure USER OPTIONS settings for compatibility.

Finally, SP4 for SS2K changed the behavior of the optimizer for implicit
conversion on mixed data type comparisons. This has persisted into the
SS2K5 framework. When you match unlike data type, use explicit conversion
to avoid the issue.

Basically, if your SS2K installation is pre-SP4, then either applying SP4 or
upgrading to SS2K5 will introduce the behavior you are describing.

http://support.microsoft.com/kb/899976/en-us

http://support.microsoft.com/kb/271566/en-us

Sincerely,


Anthony Thomas


--

"Rogers" <naissani (AT) hotmail (DOT) com> wrote