declare
        @isql varchar(2000),
        @dbname varchar(200)
        
        declare c1 cursor for select name from master..sysdatabases
        where (name not in ('master','model','msdb','tempdb')) and (DATABASEPROPERTYEX([Name] , 'IsAutoClose') = 1 OR DATABASEPROPERTYEX([Name] , 'Recovery') = 'FULL') order by name
        open c1
        fetch next from c1 into @dbname
        While @@fetch_status <> -1
                begin
                select @isql = 'ALTER DATABASE [@dbname] SET AUTO_CLOSE OFF'
                select @isql = replace(@isql,'@dbname',@dbname)
                print @isql
                exec(@isql)
                select @isql = 'ALTER DATABASE [@dbname] SET RECOVERY SIMPLE'
                select @isql = replace(@isql,'@dbname',@dbname)
                print @isql
                exec(@isql)
                select @isql='USE [@dbname] checkpoint'
                select @isql = replace(@isql,'@dbname',@dbname)
                print @isql
                exec(@isql)
                
                fetch next from c1 into @dbname
                end
        close c1
        deallocate c1