Script to change auto growth settings for all databases in SQL Server

This script is going to change the auto growth setting of database files of all databases except Master & Msdb by 100 MB. This script is very useful while performing the SQL RAP exercise.  

If you want to change the auto growth size from 100 to some other value then just modify the filegrowth value in script at below location.

BEGIN 

    PRINT 'Changing AutoGrowth option for database:- '+ UPPER(@name) 

    SET @Query  = 'ALTER DATABASE '+ @name +' MODIFY FILE (NAME = '+@vFileName+',FILEGROWTH = 100MB)' 

    EXECUTE(@Query) BEGIN 

    PRINT 'Changing AutoGrowth option for database:- '+ UPPER(@name) 

    SET @Query  = 'ALTER DATABASE '+ @name +' MODIFY FILE (NAME = '+@vFileName+',FILEGROWTH = 100MB)' 

    EXECUTE(@Query)   

I am hopeful that this script is going to be very helpful to each one of you.