Error 81;15Arithmetic overflow error ...

• pavargasq

  Say Hey Kid

  Points: 696

  More actions

  January 14, 2009 at 4:26 pm

  #128038

  Good evening

  In a production system using sqlserver 2000 a make a simple sql stament like this

  select count(*) from table_name

  As output the following error descriptions appears:

  Arithmetic overflow error error converting accessing to data type int.

  So it happens while queryng the same table in the Enterprise manager.

  this could happen because the table_name is very large ( hundred and hundred millions of records)

  how can i count the number of records this table has?

  I'll apreciate your help

• Jeffrey Williams

  SSC Guru

  Points: 89773

  More actions

  January 14, 2009 at 4:44 pm

  #927002

  You can try:

  SELECT COUNT_BIG(*)

  FROM table_name;

  Jeffrey Williams
  Problems are opportunities brilliantly disguised as insurmountable obstacles.

  How to post questions to get better answers faster
  Managing Transaction Logs

• Preet_S

  SSCrazy

  Points: 2124

  More actions

  January 20, 2009 at 10:42 am

  #929816

  Out of interest, what does sp_spaceused 'tablename' give you ?

  spaceused returns number of rows in the table and is 11 char in len. (spaceused also depends upon internal stats being up-to-date)