sql script for table rowcounts

Question

Post reply

sql script for table rowcounts

ishaan99

SSCertifiable

Points: 6261
More actions
September 23, 2005 at 1:15 pm

#363800

Does anyone have a sql handy that would give me the rowcounts of all tables in a database without using sysindexes table. any help will be greatly appreciated.
TIA

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

There's a script on this site that promises to do it...script

**ASCII stupid question, get a stupid ANSI !!!**

noeld SSC Guru Points: 96590 More actions · Answer 2

That script uses sysindexes!!

if you are planing to use it just run the following first!

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS

and you shoud be OK

Cheers,

* Noel

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

hi noel - aren't you getting ready for PASS yet ?! thought you'd be too busy to "visit this site"...yet you have time to actually go look at the script...?!?!

**ASCII stupid question, get a stupid ANSI !!!**

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 4

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

Good Hunting!

AJ Ahrens

webmaster@kritter.net

ishaan99 SSCertifiable Points: 6261 More actions · Answer 5

Thanks Noel. Thats what i was looking for. good mind reader..

noeld SSC Guru Points: 96590 More actions · Answer 6

I was afraid of "Rita" but apparently it is turning east and weakening

... did you notice that Rita and Katrina are women names

* Noel

ishaan99 SSCertifiable Points: 6261 More actions · Answer 7

Yeah good to stay away then and help the rest of us with your great brain.thanks

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

So you're afraid of girls, how is it you are married??

noeld SSC Guru Points: 96590 More actions · Answer 9

Just wait till you get married. You'll know what I mean

* Noel

sushila SSC-Dedicated Points: 35293 More actions · Answer 10

you mean you're NOT going to PASS ?!?!

btw: I believe the one that wreaked most havoc EVER was ANDREW...

**ASCII stupid question, get a stupid ANSI !!!**

sushila SSC-Dedicated Points: 35293 More actions · Answer 11

remi - it's called a catch-22 - till you're married you're not afraid of girls and as soon as you get married you live in terror...yet some men have been known to "get hitched" again and again and again...

**ASCII stupid question, get a stupid ANSI !!!**