Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display Row Count for all Tables Expand / Collapse
Author
Message
Posted Saturday, September 22, 2007 8:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 5, 2008 2:49 PM
Points: 57, Visits: 14
Comments posted to this topic are about the item Display Row Count for all Tables


Post #401413
Posted Monday, September 24, 2007 2:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:40 AM
Points: 108, Visits: 310
cadebryant (9/22/2007)
Comments posted to this topic are about the item Display Row Count for all Tables

You could also use the system stored procedure sp_spaceused 'YourTableName' .  I actually saved this and other system stored procedures on my "Keyboard Shortcuts" for easy access.

Sal Young
MCITP Database Administrator

Post #402226
Posted Tuesday, December 18, 2007 2:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 9, 2008 4:58 AM
Points: 239, Visits: 38
This is not an efficient script, it doesn't include tables without clustered indexes(primary key).
Post #434172
Posted Tuesday, December 18, 2007 9:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2008 8:47 PM
Points: 8, Visits: 18
This script has a fault,that is,the results don't contain those tables which not exists any indexes.
Post #434614
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse