Arithmetic overflow error converting expression to data type int

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  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

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  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