This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script to find the all database auto-growth settings in the SQL Server.
As a Database Administrator, many times I need to find auto-growth settings and size of all databases in SQL Server.
This is very important for me because, for different reporting databases, I didn’t set limit for size.
You can find all databases auto-growth by using sp_Msforeachdb.
1 2 |
SET STATISTICS TIME ON exec sp_MSforeachdb 'use [?]; EXEC sp_helpfile' |