Find table size

Expand Post »

Hello all,
I have a MS SQL database which is meant to be quite small. For some reason it appears to have grown to 1GB in size.
There are quite a few tables in the database. Is there any way to get a report (using enterprise manager) of the table sizes for the database?

Thanks in advance.
James

Similar Threads

Make Sure Downloaded Files Are Easy to Find Later in Windows tips 'n' tweaks
C++hash table lookin' 4 help~~ in C++
Find table size in MySQL

jamesg

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2005

Permalink

Jun 30th, 2005

Re: Find table size

Quote originally posted by jamesg ...

Hello all,
I have a MS SQL database which is meant to be quite small. For some reason it appears to have grown to 1GB in size.
There are quite a few tables in the database. Is there any way to get a report (using enterprise manager) of the table sizes for the database?

Thanks in advance.
James

I dont know about enterprise manager...But you can use the query analyzer..

Check out these threads..
http://www.tek-tips.com/faqs.cfm?fid=2519

http://www.extremeexperts.com/SQL/Sc...zeOfTable.aspx

http://www.sql-server-performance.co...?TOPIC_ID=4924

Hope it helps

Letscode

Reputation Points: 11

Solved Threads: 6

Junior Poster

Offline

175 posts
since Feb 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: SQL does not substract

Next Thread in MS SQL Forum Timeline: Query

DaniWeb Message

Cancel Changes

User Name
Password