How can we dis-connect all the active users on sql-server 2005 express using sql

Question

How can we dis-connect all the active users on sql-server 2005 express using sql

Answer 1

Hi, take a look at this link
http://blog.sqlauthority.com/2006/12/01/sql-server-cursor-to-kill-all-process-in-database/

Answer 2

Just fire this sql query:

USE [master] 
GO

 ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE; RESTORE DATABASE MyDB FROM DISK = 'backupfile path' WITH REPLACE

Answer 3

USE [master]
GO
ALTER DATABASE [YourDB] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

Your Restore Statement

ALTER DATABASE [YourDB] SET  MULTI_USER
GO