GW1948
Can anyone please tell me of a way of generating a list of all user databases and their size with one command or view
Thanks,
Getting started with SQL Server
Refer to Books Online, Topic: sys.database_files
This will return the size as the number of 8K pages, so do the math in your query.
select
* from sys.master_files
Will also give you useful information.