RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

SQL switch recovery model (BULK-LOGGED to SIMPLE e viceversa)

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...
Categoria: Sql Server ALL
mercoledì, 03 feb 2010 Ore. 14.03

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003