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