Post reply

Arithmetic overflow error converting expression to data type int

  • February 17, 2010 at 5:02 pm

    #219231

    Hi,

    I'm seeing the below message in Spot light frequently. Is some thing I need to verify why this is occuring?

    Time Connection Action Details Severity Alarm

    02/17/2010 11:01:17 AM Ins1 Alarm raised SQLServer Error(8115) Arithmetic overflow error converting expression to data type int. Information Procedure Cache Contents

    Thanks

  • February 17, 2010 at 6:27 pm

    #1120594

    Two options:

    Run a trace on your system and try to find what is running at the same time that spotlight kicks out that error message

    or

    Check with SpotLight and see if they have any insight.

    Something that is running is putting a value that is too large into a variable.

    Reference:

    http://msdn.microsoft.com/en-us/library/ms163363.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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