Sometimes you may want to know the total row counts of all tables in a database. The script below will give you a rough idea. However, it is not guaranteed to be accurate, though. It works in both Sql Server 2000 and Sql Server 2005.

select sum(rowcnt) from sysindexes inner join sysobjects on sysindexes.id=sysobjects.id where sysobjects.xtype = ‘U’
and sysobjects.name not in (‘dtproperties’)