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