How many times this articles has been read? 38
This article has 136 total words. (Including header)
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 |
| |
--> (Word)
--> (PDF)
--> (Epub)
--> (Text)
--> (XML)
--> (OpenOffice)
--> (XPS)
--> (MHT)
