john.vanda (11/3/2009)

---

This happens if you don't want your outsourced IT Dept. seeing accounting data, such as payroll. SQL Server single user mode must use a separate set of permissions that, when active, allows anyone with local admin permissions rights to the data. So, the IT Dept. could still get into the data if they switched it to single user mode? Nice.

I know, right. Very uncomfortable feeling knowing that the network team could still get in if they really wanted to.