038. Generate Shrink Script for each Database File – SQL Server Script

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts
SELECT 
	'USE ' + db_name(dbid) + char(13) + 'DBCC SHRINKFILE (N' + quotename(sf.name,'''') + ' ,truncateonly)' 
FROM sys.sysaltfiles AS sf
INNER JOIN sys.databases d 
	ON sf.dbid = d.database_id
WHERE d.state_desc = 'online'
--AND db_name(dbid) = 'DATABASE_NAME'

Related Posts: