Home Forums SQL Server 7,2000 Administration Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

  • This may have been answered already but this worked for me:

    sp_MSforeachtable "select '?', count(1) from ?"