Query to find how many records in your database

select t.name [TableName],r.rowcnt [RowCount] 
from sysobjects t join sysindexes r on t.id=r.id
where r.indid in (0,1) and xtype='U' and t.name<>'sysdiagrams'
order by r.rowcnt desc compute sum(r.rowcnt)