If a SOX Audit requires that an administrator on a Windows Server not be able to grant himself access to a SQL Server, then please ask Microsoft to remove the...

It's tragic that this excellent article is being dragged down by bickering over a title. Take the article for what it is (e.g. informative), and move on. Stop...

Nice article Rudy. Thanks for sharing!

Alun,

It blew me...

sprasad-897633 (11/3/2009)

---

sqlservr.exe -m

When you shut down the cmd window used to open sqlserver in single user mode, does the sql server automatically switch to a multiuser mode or do we...

ALUN WILLIAMS (11/3/2009)

---

The main question (I think) is unanswered:

If you have removed BUILTIN\Administrators and all other administrative access to the SQL instance, how can you log into the SQL instance...

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...

What is your question?

chrismj (11/3/2009)

---

The real way is to use the Dedicated Administrator Connection. You need to be on the physical box and member of sysadmin, and you can use either sqlcmd or...

Per MSDN:

Under certain circumstances, you may have to start an instance of SQL Server in single-user mode by using the startup option -m. For example, you may want to change...

I'm digging this solution. I really like to be able to filter my results, so I took the code from Dan (nice code Dan) that used the trick from Adam...