Using SQL Server 2005 and a bit of good old T-SQL you can obtain the row count for all tables in your database with this handy piece of code ...

SELECT    object_id,

          OBJECT_NAME(object_id)  AS  ObjectName,

          SUM (row_count)         AS  RowCnt

FROM      sys.dm_db_partition_stats

WHERE     index_id  <  2

AND       OBJECTPROPERTY(object_id, 'IsUserTable')  =  1

GROUP BY  object_id

Thanks to Ferry Nugraha for this code!

   1:  [Test]

   2:          public void BlogInsert()

   3:          {           

   4:              using (TransactionScope scope = new TransactionScope()) 

   5:              {

   6:                  DateTime postedDate = new DateTime(2006, 11, 23);

   7:                  string title = "XML Notepad 2006";

   8:                  string contents = "this is the contents from the blog";

   9:                  string blogUrl = "http://yellowduckguy.spaces.live.com/";

  10:   

  11:                  int expectedRowsAffected = 1;

  12:                  int actualRowsAffected = BlogDataAccess.BlogAdapterInsert(postedDate, title, contents, blogUrl);

  13:   

  14:                  Assert.AreEqual(expectedRowsAffected, actualRowsAffected);

  15:              }

  16:          }

   1:          [TestMethod]

   2:          public void BlogInsert()

   3:          {           

   4:              using (TransactionScope scope = new TransactionScope()) 

   5:              {

   6:                  DateTime postedDate = new DateTime(2006, 11, 23);

   7:                  string title = "XML Notepad 2006";

   8:                  string contents = "this is the contents from the blog";

   9:                  string blogUrl = "http://yellowduckguy.spaces.live.com/";

  10:   

  11:                  int expectedRowsAffected = 1;

  12:                  int actualRowsAffected = BlogDataAccess.BlogAdapterInsert(postedDate, title, contents, blogUrl);

  13:   

  14:                  Assert.AreEqual(expectedRowsAffected, actualRowsAffected);

  15:              }

  16:          }