How do I find size in KB of particular table in da

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

GRN Hall of Fame Points: 3260 More actions · Answer 1

Hall of Fame

Points: 3260

May 27, 2003 at 12:58 am

EXEC sp_spaceused <tablename>

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Cross post in different categories?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

pmanisekaran SSC-Addicted Points: 401 More actions · Answer 3

Thanks for it.

I wrongly posted it in different section, so i reposted.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

No problem!

I think that's one feature Snitz Forum Software is missing. You can only delete a topic, but not change a topic's category.

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

pmanisekaran SSC-Addicted Points: 401 More actions · Answer 5

yeah, we need facility to move a posting from one category to another

Vik Nat Hall of Fame Points: 3930 More actions · Answer 6

In SQL 7 you can use EM to see size a particular table is using.