Post reply

HELPPPPPPPPPPPPP-Sql 2000 Upgrade

  • August 10, 2003 at 2:09 am

    #159836

    After upgrading from sql server 7 to 2000 i getting the error:

    Server: Msg 248, Level 16, State 1, Line 1

    The conversion of the varchar value '13495112479' overflowed an int column. Maximum integer value exceeded.

    The statement has been terminated.

  • August 10, 2003 at 10:23 pm

    #469322

    Hi there

    What approach did you take with the upgrade?

    Is this error your application table related, or system?

    Any fundamental architecture/OS changes? (long shot)

    The error is fair enough, and of course select cast('13495112479' as bigint) works a treat. Double check your v7 instance of the app and determine if this wasnt a problem previously.

    Cheers

    Ck

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply