I'm resoring my sql database on a nightly basis, but sometimes it fails as
some users leave there connection to the database up.
Could someone give me the script, or point me in the right direction for a
script that will disconnect all open sessions.

Thanks a lot

You can use Alter Database to put the database into single user mode and
use the with rollback immediate clause. There is a sp to kill all users at
http://www.dbmaint.com/download/util...kill_users.sql.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

"James" <Homer@jamco> wrote

Hi,

The script will be :-

use Master
go
Alter database <dbname> set single_user with Rollback immediate
go
Restore database <dbname> from disk='filename'
go
Alter database <dbname> set multi_user


The above commands will remove all the user connections from the database ,
set to single user and do the restore and after the restore the database is
set to Multi user.

Thanks
Hari
MCDBA

"James" <Homer@jamco> wrote