USE master
GO
DECLARE @dbname sysname, @cmd varchar(1000)
DECLARE db_recovery_cursor CURSOR FOR
SELECT name from sysdatabases

OPEN db_recovery_cursor
FETCH NEXT FROM db_recovery_cursor INTO @dbname
WHILE @@FETCH_STATUS = 0

BEGIN
IF (SELECT DATABASEPROPERTYEX(@dbname,'RECOVERY')) <> 'simple' and @dbName <> 'tempdb' BEGIN

SET @cmd = 'ALTER DATABASE "' + @dbname + '" SET RECOVERY simple'

EXEC(@cmd)
PRINT @dbname
end
FETCH NEXT FROM db_recovery_cursor INTO @dbname
END
CLOSE db_recovery_cursor
DEALLOCATE db_recovery_cursor