Multidatabase : Switch da MODEL BULK-LOGGED a SIMPLE e viceversa
--SET BULK-LOGGED MODE
USE masterGO
-- Declare a variable to store the value [database name] returned by FETCH.DECLARE @dbname sysname, @cmd varchar(1000)
-- Declare a cursor to iterate through the list of databasesDECLARE db_recovery_cursor CURSOR FORSELECT name from sysdatabases-- Open the cursorOPEN db_recovery_cursor
-- Perform the first fetch and store the value in a variable.FETCH NEXT FROM db_recovery_cursor INTO @dbnam
Leggi tutto il post...