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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 system SP

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2005-08-17 : 16:43:34
Is there a system stored procedure that shows the size of each database in one server?
sp_spaceused only show the size of one dataabse.


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-08-17 : 16:44:30
Check out sp_databases. The size will be in KB.

Tara
Go to Top of Page
   

- Advertisement -