mannaggia (2/15/2011)

---

I just do this:

ALTER DATABASE dbname
	SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE dbname
	SET MULTI_USER
GO

Any advantage or disadvantage over the script?

TravisDBA (2/15/2011)
This works easier for me. The only reason to kill all the spids usually anyway is to put the database into another mode besides multi_user.

mannaggia (2/15/2011)

---

I use it when I need to restore a database and there are open connections to the database I want to restore. (This is usually during development when I need to restore a copy of a production database onto a staging or development server.)

mannaggia (2/15/2011)

---

I just do this:

ALTER DATABASE dbname
	SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE dbname
	SET MULTI_USER
GO

Any advantage or disadvantage over the script?