SQL Server - Is there a way to query the specific Size and Space available settings for each Database, including system databases on an instance?
Just check the properties of the model database - everything else being equal a new database is created using the model database as a template.
If you want to change the default size, resize your model database - job done.
Note however if the database creation script supplies a specific value that will take precedence.
re-read the question including your title and I think you want the results of running
exec sp_helpdb

or try if you want to see the space available
exec sp_msforeachdb &quot;use [?]; exec sp_spaceused&quot;