Shrink all Databases in on go

Shrink All DBs




SELECT
      'USE [' + d.name + N']' + CHAR(13) + CHAR(10)
+ 'Checkpoint;' + CHAR(13) + CHAR(10)
+ 'DBCC FREEPROCCACHE;' + CHAR(13) + CHAR(10)
+ 'GO' + CHAR(13) + CHAR(10)
+ 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)' + CHAR(13) + CHAR(10)
+ 'GO'  + CHAR(13) + CHAR(10)
    + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
FROM
         sys.master_files mf
    JOIN sys.databases d
        ON mf.database_id = d.database_id
WHERE d.database_id > 4
And mf.name like '%log';