Thanks, great question!

- webrunner

Eric M Russell (8/29/2016)

---

You'll need to create this database on another instance for which you are the only SYSADMIN. Also, you'll need to enable transparent database encryption (TDE) on this...

Great question when combined with the discussion here. Aside from the recommendations about how to improve the question itself, I learned a lot from this example overall.

Thanks!

- webrunner

More days than not I still feel like a junior DBA. There is so...

Along those lines, I think it was a joke that one of the other choices - ...

Thanks for this script. It's very useful.

- webrunner

Great question, thanks.

- webrunner

Thanks - great question.

- webrunner

Thanks, great question. The behavior is not at all what I expected, but it is good to know.

- webrunner

Thanks, Steve! Great question.

- webrunner

Sean Lange (7/7/2016)

---

webrunner (7/7/2016)

---

Like many others who have posted comments, I also first thought all 4 would be required for a strong SQL password. And it does stand to reason...

+1 🙂

Like many others who have posted comments, I also first thought all 4 would be required for a strong SQL password. And it does stand to reason that empirically the...

a.m 46061 (7/7/2016)

---

Killing connections like that reminds me of my Sybase days!

How about a one liner?

ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

That will drop all user connections apart from...

Thanks, great question.

- webrunner