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
+ '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