forked from vincent/notebook
8 lines
330 B
SQL
8 lines
330 B
SQL
SELECT db.name AS DATABASE_NAME, mf.name AS FILE_NAME,
|
|
N'ALTER DATABASE [' + db.name + '] MODIFY FILE ( NAME = [' + mf.name + '], FILEGROWTH = 64 MB);'
|
|
FROM sys.master_files AS mf
|
|
JOIN sys.databases AS db
|
|
ON mf.database_id = db.database_id
|
|
WHERE is_percent_growth = 1
|
|
AND db.database_id > 4;
|