Recently one of my friend was looking for a script to get row count in all user table, so we come up with 3 different ways of doing the same thing......
1. Using SysIndexes ROW column
2. Using un-documented "sp_MSforeachtable" procedure
3. Using old cursor way, loop through each table (count*) to get the count