allDbsRecoverySimple.sql

USE MASTER

declare

	@isql varchar(2000),

	@dbname varchar(64)

	declare c1 cursor for select name from master..sysdatabases where name not in ('master','model','msdb','tempdb')

	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