[SQL] MS SQL - shrink all log files

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