Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cjgaddy

  1. cjgaddy

    How to List #ROWS in Every Table in Database?

    Terry, I really like this one: exec sp_MSforeachtable 'select count(*) "?" from ?' Output looks like this (snipped a bit): name rows reserved data APAdjust 63902 57736 KB 56656 KB ... P_Balances 4446 4544 KB 4440 KB ... etc etc Nice...
  2. cjgaddy

    How to List #ROWS in Every Table in Database?

    Sorry PAUL that I called you Dave - Hate doing that sort of thing! Jack
  3. cjgaddy

    How to List #ROWS in Every Table in Database?

    Can't get Terry's 'Space' suggestion to work (Query Analyzer): exec sp_MSforeachtable 'exec sp_spaceused ?' I get this error: Server: Msg 170, Level 15, State 1, Line -1074292529 Line 1: Incorrect syntax near '.'. Also, Dave, how do you weave your exec sp_MStablespace N'[dbo].[tabname]' into...
  4. cjgaddy

    How to List #ROWS in Every Table in Database?

    Thanks Terry for the info on Listing ROW COUNTS for All Tables in a Database. You're Amazing. Thank you... Jack
  5. cjgaddy

    How to List #ROWS in Every Table in Database?

    Is there a way in Enterprice Manager or Query-analyzer (or ??) to get a Simple List of All the Tables in a Database and the number of rows in each Table? (icing would be to also see K-bytes consumed by each table). I'm running Solomon IV Financials, and its database has about 200 Tables. I...
See more

Part and Inventory Search

Back
Top