A SQL Server script to generate the Shrink commands for all the databases in an instance.

generate_shrink_commands.sql

DROP TABLE #f 
GO 
CREATE TABLE #f (name sysname, fileid int, filename sysname, filegroup sysname null, 
size sysname, maxsize sysname, growth sysname, usage sysname) 
GO 
EXEC sp_MSforeachdb 'DECLARE @s VARCHAR(8000);
USE [?]; 
TRUNCATE TABLE #f;
INSERT #f (name, fileid, filename, filegroup, size, maxsize, growth, usage ) 
EXEC sp_helpfile 
SELECT @s = ''use [?]; DBCC SHRINKFILE ('''''' + name + '''''')''
FROM #f
WHERE usage = ''log only''
AND ''?'' NOT IN (''master'', ''tempdb'', ''model'', ''msdb'')
PRINT @s'