How to close existing connections to a DB

Question

I want to close the existing connections to an MS SQL Server so that I can do a restore on that database programatically.

Accepted Answer

This should disconnect everyone else, and leave you as the only user:

```
alter database YourDb set single_user with rollback immediate
```

Note: Don't forget

```
alter database YourDb set MULTI_USER
```

after you're done!

Solution