Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2011-07-20 : 22:25:44
|
| Hi,Could someone suggest good scripts for achieving the following:1. Find out the size of each database on the server2. Find out the size (data/index/rowcount) of each table in the database3. Find out the sizes of the database files4. Find out free/used space on each drive on the machineI have created scripts for each of these in SQL Server 2000, but thinking that there could be better ways in SQL Server 2008 server I am using now, which is why would like to find out how others are achiving this now.Thank you! |
|
|
|
|
|
Space utilization scripts