RS First Dynamics NAV Blog


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

DB Sql Server "Change Db Status"

Change the database context to Master and allow updates to system tables:   Use Master   Go   sp_configure 'allow updates', 1   reconfigure with override   GoSet the database in Emergency (bypass recovery) mode:   select * from sysdatabases where name = '<db_name>'   -- note the value of the status column for later use in # 6   begin tran   update sysdatabases set status = 32768 where name = '<db_n 
Leggi tutto il post...
Categoria: Sql Server ALL
lunedì, 22 feb 2010 Ore. 17.44

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