USE master
GO
ALTER DATABASE @dbName
SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE @dbName
SET ONLINE
OR simply
Right Click database -> Tasks -> Take database offline
Showing posts with label drop all database connections. Show all posts
Showing posts with label drop all database connections. Show all posts
How to drop all Database connections (TSQL)
OR simply
Right Click database -> Tasks -> Take database offline
Subscribe to:
Posts (Atom)
Posts
