Automated Process to Shrink database log files
-- Automated Process to Shrink database log files of all online databases whose size is Greater than 10000 DECLARE @loopStart INT = 1 , @LoopEnd INT; DECLARE @t TABLE ( idx INT IDENTITY(1, 1) , DBName VARCHAR(MAX) , FileType VARCHAR(150) , Location VARCHAR(MAX) , LogicalFileName VARCHAR(MAX) , FileSize BIGINT ); INSERT INTO @t ( DBName , FileType , Location , LogicalFileName , FileSize ) SELECT db.name , type_desc , physical_name , ...