Error: "Arithmetic overflow error converting numeric to data type numeric."

Hi,

I got the following error.

Arithmetic overflow error converting numeric to data type numeric.

I got this error while I was moving to SQL server 2000 to 2005. The error i got is for a single database & not for others so I dont think its regarding this up gradation.

Do you have experienced such error before?

Please check what are the data types involved, and what are the amounts involved?

Arithmetic overflow error converting numeric to data type numeric.

I think the problem is in the sql select statement used in OleDbAdapter OR you are passing wrong parameter .

Solved!
Decimal(5,3) does not alows a value greater that 99.999 but decimal(7,3) solves my issue and i can then store 9999.999