Find table size

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

jamesg

Newbie Poster

2 posts since Jun 2005

Reputation Points: 10

Solved Threads: 0

6 Years Ago

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/Scripts/FindSizeOfTable.aspx

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4924

Hope it helps

Letscode

Junior Poster

175 posts since Feb 2005

Reputation Points: 11

Solved Threads: 6

This article has been dead for over three months

You