January 14, 2009 at 4:26 pm
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
January 14, 2009 at 4:44 pm
You can try:
SELECT COUNT_BIG(*)
FROM table_name;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 20, 2009 at 10:42 am
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)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply