I'd like to write a query to list the tables in a DB and the row count for each table

I got as far as SELECT name FROM sysobjects WHERE xtype = 'U'

That yields a nice list of the tables in the DB. I've tried to write a UDF using the table name as a parameter, that would return the row count, and can't figure out to get that UDF to work

Any ideas?