I'm trying to get a rowcount (it doesn't have to be exact) of all the user tables in a database. I'm currently extracting the table names from sysobjects and then just building up some sql to put the results in a TableRowCount table.
Problem is with very large tables it takes a long time. The sproc sp_spaceused is almost instant so I presume there's a quicker way of doing it. Any ideas ?