DB SQL in Simple Mode (Microsoft SQL Server)

Send Us a Sign! (Contact Us!)
--> (Word) --> (PDF) --> (Epub) --> (Text)
--> (XML) --> (OpenOffice) --> (XPS) --> (MHT)

Un piccolo [gs script] SQL per convertire tutti i [gs database] utente in una [gs istanza] SQL in Simple mode.

[tweet]

declare @name VARCHAR(50)
declare @sql VARCHAR(1000)
declare db_cursor cursor for 
SELECT name from master..sysdatabases where name not in ('master','model','msdb','tempdb')
open db_cursor
fetch NEXT from db_cursor into @name
while @@fetch_status = 0
begin
 set @SQL = 'ALTER DATABASE [' + @name + '] SET RECOVERY SIMPLE'
 exec (@SQL)
 fetch next from db_cursor into  @name
end
close db_cursor
deallocate db_cursor

SOURCE

LINK

LANGUAGE
ITALIAN