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)
 SQL script to capture all databases size in the sql server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-16 : 10:30:03
Peter writes "I am trying to create a sql script which display the name of the database, size of the database, space allocation, and data size. I have tried sp_helpdb, sp_spaced used, and select name from sysdatabases to script out the name but could not accompblish what I need."
   

- Advertisement -