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 |
|
shahab03
Starting Member
28 Posts |
 Posted - 2008-04-23 : 12:01:35
|
| I would like to generate a report that lists each database in both sql 2000 and 2005 instance alongwith their size. I can get the size sysfiles... perhaps i can join it with sysdatabases ?thanks ps. posted in the wrong forums before. apologies. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 12:17:21
|
| Try:Sp_databases |
 |
|
|
shahab03
Starting Member
28 Posts |
Posted - 2008-04-23 : 12:24:26
|
| wow.. works like a charm.. nice.. thanks a bunch |
|
|
|
|
|
|
database size report