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"