SET NOCOUNT ON

DECLARE @cmd VARCHAR(150) -- command

DECLARE db_cursor CURSOR FOR 
SELECT 'USE [' + d.name + N']' + ' ' + 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)' cmd
  FROM sys.master_files mf 
  JOIN sys.databases d ON mf.database_id = d.database_id 
 WHERE d.database_id > 4 and mf.type_desc = 'LOG'

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @cmd   

WHILE @@FETCH_STATUS = 0   
BEGIN   
       PRINT @cmd
	   EXEC(@cmd)
       FETCH NEXT FROM db_cursor INTO @cmd
END   

CLOSE db_cursor   
DEALLOCATE db_cursor