#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    1
    Rep Power
    0

    Arithmetic overflow error converting numeric to data type numeric


    I recently upgraded SQL7 to SQL 2000. I've migrated about 50 databases and all are working well except 1. I'm getting and error "Arithmetic overflow error converting numeric to data type numeric". The code was working before I made the upgrade. Anyone have any ideas on what is going on here. Thanks in advance.
    Bill
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0
    the error typically occurs when you are trying to pass a numeric value that is too large...

    example, trying to pass 12345.67 into a numeric(4,2) would generate the error.

IMN logo majestic logo threadwatch logo seochat tools logo