why don't do your best

-- Declare variables DECLARE @SqlStatement as nvarchar(max) DECLARE @LogFileLogicalName as sysname -- Alter the database to simple recovery SET @SqlStatement = 'ALTER DATABASE ' + DB_NAME() + ' SET RECOVERY SIMPLE' EXEC ( @SqlStatement ) -- Make sure it has been altered SELECT [name], [recovery_model_desc] FROM sys.databases WHERE [name] = DB_NAME() -- Set the log file name variable SELECT @LogF..