DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   MS SQL (http://www.daniweb.com/forums/forum127.html)
-   -   Find table size (http://www.daniweb.com/forums/thread27008.html)

jamesg Jun 30th, 2005 2:56 am
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

Letscode Jun 30th, 2005 11:20 am
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


All times are GMT -4. The time now is 9:47 pm.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC