USE [master]
DECLARE @dbname NVARCHAR(MAX) -- database name  
DECLARE @logname NVARCHAR(MAX) -- log name  


declare db_cursor CURSOR FOR  
select f.name as logname, d.name as dbname
from sys.master_files f
inner join sys.databases d on f.database_id = d.database_id
where f.type_desc = 'LOG'
and f.file_guid is not null

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @logname, @dbname


WHILE @@FETCH_STATUS = 0   
BEGIN   
	PRINT 'use [' + @dbname + '];'
	PRINT 'go'
	PRINT 'DBCC SHRINKFILE (N''' + @logname + ''' , 0, TRUNCATEONLY);'
	PRINT 'go'
	FETCH NEXT FROM db_cursor INTO @logname, @dbname
END   

CLOSE db_cursor   
DEALLOCATE db_cursor