How can we help you today? How can we help you today?

Arithmetic overflow error converting expression

When I connected to my very large database server I got a SQL Server unreachable error with the detail message Arithmetic overflow error converting expression to data type int. This server stores 18.2 TB of data and I think you may have a 32-bit arithmetic problem.
d3j409
0

Comments

1 comment

Sort by
  • Nigel Morse
    We should be using 64-bit ulongs for things size related, but one must have slipped through the net.

    Could you please send me the log files which can be found in 
    C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\Logs\SQL Response AlertRepository
    to nigel.morse at red-gate.com which should help me pinpoint the location.

    We have tested some pretty large databases - but I don't think we even have 18Tb of disk to even try that size!!

    Thanks
    Nigel Morse
    0

Add comment

Please sign in to leave a comment.