Please support our MS SQL advertiser: Programming Forums
Views: 26491 | Replies: 1
 |
•
•
Join Date: Jun 2005
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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 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
•
•
Join Date: Feb 2005
Posts: 175
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
•
•
•
•
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
Save White Tiger
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
