DECLARE @spid varchar(10)

SELECT @spid = spid
FROM master.sys.sysprocesses
WHERE dbid IN (DB_ID('dbName'))

WHILE @@ROWCOUNT <> 0
BEGIN
 EXEC('KILL ' + @spid)

 SELECT @spid = spid
 FROM master.sys.sysprocesses
 WHERE 
  dbid IN (DB_ID('dbName')) AND 
  spid > @spid 
END

alter database MyDatabase set offline with rollback immediate

quote:

---

Originally posted by Michael Valentine Jones

This is even easier, because once the database is offline, it is impossible for anyone to connect to it.

alter database MyDatabase set offline with rollback immediate

CODO ERGO SUM

---

quote:

---

Originally posted by sodeep

quote:

---

Originally posted by Michael Valentine Jones

This is even easier, because once the database is offline, it is impossible for anyone to connect to it.

alter database MyDatabase set offline with rollback immediate

CODO ERGO SUM

---

I think you can't restore DB in offline mode. You can put in Single User mode but transactions has to be completed.

---

declare @DB_Name sysname
set @DB_Name = 'MyDatabase'

-- Take DB offline so no users are in database during restore
if databasepropertyex(@DB_Name,'Status') = 'ONLINE'
begin
exec ('
use master
print ''Set Database  ' + @DB_Name + '  to OFFLINE''
alter database ' + @DB_Name + ' set offline with rollback immediate
')
end

--Restore command, etc.