I think the answer is wrong on 2005. Look at the following:

select

sum(row_count)

from

sys.dm_db_partition_stats

where

object_id = object_id('dibs_tmb_saalist') and

(index_id = 0 or index_id = 1)

select count(*) from dibs_tmb_saalist

go

Produced:

(No column name)

310825

(No column name)

311992

That is a pretty significant error in my book. Query 1 is the only reliable method posted.

HTH -- Mark D Powell --

Note - above is corrected to include index_id line which reduced the error but did not eliminate it.