Pasted

USE [master]
DECLARE @name NVARCHAR(MAX) -- database name  
 
declare db_cursor CURSOR FOR  
SELECT name 
FROM MASTER.sys.databases 
WHERE name NOT IN ('master','model','msdb','tempdb') and recovery_model_desc <> 'SIMPLE'
 
OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   
 
WHILE @@FETCH_STATUS = 0   
BEGIN   
    
    PRINT 'ALTER DATABASE [' + @name + '] SET RECOVERY SIMPLE WITH NO_WAIT'
    PRINT 'GO'
    FETCH NEXT FROM db_cursor INTO @name   
END   
 
CLOSE db_cursor   
DEALLOCATE db_cursor