Forum Discussion

ia01's avatar
ia01
Level 6
12 years ago

Arithmetic overflow error converting expression to data type int

Hi,   Just trying to run the following query, it was working for a while, suddenly started getting "Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data t...
Enterprise Vault
Information Governance
Tip-How to
  • JesusWept3's avatar
    JesusWept3
    12 years ago

    You're going to have to CAST the item to a bigger int

    SUM(CONVERT(bigint,SS.ItemSize))

ia01's avatar
ia01
Level 6
12 years ago

Thanks

SUM(CONVERT(bigint,SS.ItemSize)) worked perfectly as archived Data is just over 2TB now for that particular archive :-)

Thanks again for your help, really appreciate!