Receiving error "Arithmetic overflow error converting expression to data type int" while running sp_updatestats

• traughber

  SSC-Addicted

  Points: 419

  More actions

  March 23, 2016 at 2:18 pm

  #309343

  While running sp_updatestats on a database (literally just "exec sp_updatestats") I get the error "Arithmetic overflow error converting expression to data type int". See the output below. Anyone know what this could be?

  Updating [maint].[TempTableMonitor]

  [PK_TempTableMonitor] has been updated...

  Msg 8115, Level 16, State 2, Line 1

  Arithmetic overflow error converting expression to data type int.

  [TotalSpaceReserved] has been updated...

  Msg 8115, Level 16, State 2, Line 1

  Arithmetic overflow error converting expression to data type int.

  [TotalSpaceUsed] has been updated...

  [TotalPagesReserved] has been updated...

  [TotalDataPagesUsed] has been updated...

  [TotalPageUsed] has been updated...

  [TotalRowCount] has been updated...

  [NumberOfTablesContaingData] has been updated...

  [NumberOfTables] has been updated...

  9 index(es)/statistic(s) have been updated, 0 did not require update.

• manuel.amorim

  SSC Enthusiast

  Points: 129

  More actions

  April 25, 2016 at 9:01 am

  #1874266

  Hello

  I'm getting the same error.

  Anyone have any idea about the reason to this?

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  April 25, 2016 at 10:19 am

  #1874302

  manuel.amorim (4/25/2016)

  ---

  Hello

  I'm getting the same error.

  Anyone have any idea about the reason to this?

  Quick questions, can you post the full output of SELECT @@VERSION;,

  any chance that there are any read only filegroups/objects in the database and last but not least, are you running this as sysadmin?

  😎