/ SQL Query to get ALTER Database Modify command

SQL Query to get ALTER Database Modify command

SELECT  'USE [MASTER] ' + CHAR(13) + 'ALTER DATABASE [' + d.name + N'] '
    + 'MODIFY FILE (NAME = ''' + mf.name + N''', FILENAME= '''+ mf.physical_name+ N''')'
    + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
FROM    sys.master_files mf
    JOIN sys.databases d ON mf.database_id = d.database_id
WHERE   d.database_id > 4
        AND mf.type=1 and mf.physical_name like 'T:\%' and mf.name like 'WSS_%'


select 'ALTER DATABASE ['+ DB_NAME(database_id) +'] MODIFY FILE ( NAME = ''' +  name  + ''', FILEGROWTH = 100MB ) ' from sys.master_files