row count for tables in DB

• psconsulting

  SSC Eights!

  Points: 944

  More actions

  January 8, 2003 at 9:16 am

  #80606

  Anyone know how I would be able to get a row count for all tables out there in a defined DB?

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  January 8, 2003 at 9:21 am

  #445855

  Here is a script that gives you record counts for every table in every database on a server.

  http://www.sqlservercentral.com/scripts/contributions/341.asp

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• dj_meier

  SSCrazy

  Points: 2732

  More actions

  January 8, 2003 at 11:56 am

  #445871

  Here's a "quick and dirty" method for all tables in a single DB:

  EXEC sp_MSForEachTable 'EXEC sp_spaceused ''?'''

  -Dan

  
  -Dan