Query to Identify Database Settings for SharePoint in SQL Server

CREATE TABLE #GrowthTable

(

          Type_Desc varchar(50),

          Name varchar(500),

          Physical_Name varchar (max),

          State_Desc varchar(50),

          Size varchar(500),

          Max_Size varchar(500),

          Growth varchar(50),

          Is_Percent_Growth varchar(50)

);

exec sp_msforeachdb "use [?]; insert into #GrowthTable select Type_Desc, Name, Physical_Name, State_Desc, Size, Max_Size, Growth, Is_Percent_Growth from sys.database_files"

select * from #GrowthTable

drop table #GrowthTable