In SQL Server 2000
sp_configure 'allow' ,1
GO
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = 'SQLDBPool'
GO
sp_configure 'allow', 0
GO
Reconfigure with override
go
IN SQL Server 2005/2008
ALTER DATABASE sqldbpool
SET emergency
Showing posts with label Emergency Mode. Show all posts
Showing posts with label Emergency Mode. Show all posts
Wednesday, January 26, 2011
Subscribe to:
Posts (Atom)