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 |
|
dave
Starting Member
15 Posts |
 Posted - 2002-10-15 : 02:24:51
|
| I know there's a pretty simply query that I can run which returns the names of the databases on a server, the amount of space allocated to each as well as the percentage of this space used by each. I used it only last week and now can't, for the life of me, remember what it was, or where to start.Can someone give me a quick kick in the head to remind me.....or just tell me?Thanks! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-10-15 : 09:26:29
|
Hey DaveTry this :Exec sp_MSForEachDB 'select ''?'', * from ?..sysfiles'Is that another  you owe me now ?  Damian |
 |
|
|
dave
Starting Member
15 Posts |
Posted - 2002-10-15 : 18:08:00
|
| That's 12 - 0 ...... |
|
|
|
dave
Starting Member
15 Posts |
Posted - 2002-10-15 : 18:09:53
|
| There was actually another query that I used which had three columns, one listed the database name, the next the amount of space allocated for the database and the third the percentage of this space that was used. This one's actually probably better so I'll be leaving it at that! |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-10-16 : 14:57:26
|
| This is what I usually use to pull all db infosp_MSForEachDB 'sp_helpdb ''?'''Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Dababase size and % used