In this post, I am going to share one script to find all database auto-growth settings of SQL Server.
As a Database Administrator, many times I require to find auto-growth settings and size of all databases in SQL Server.
This is very important for me because for different reporting database, I have not set unlimited size.
You can find all database auto-growth by using sp_Msforeachdb.
SET STATISTICS TIME ON
exec sp_MSforeachdb 'use [?]; EXEC sp_helpfile'