August 10, 2003 at 2:09 am
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
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
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