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
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.