Try this

SELECT name,default_database_name,is_disabled,type_desc

FROM sys.server_principals

WHERE type IN ('u','g','s');

I thought this was a good summation of the psychology of a DBA. It is tough riding that line between overly egotistical and too humble. The right mix...

Lynn Pettis (9/6/2012)

---

Okay, you're...

jrichards54 (9/6/2012)

---

I just ran the DOS Command with the > in it and got "Access Denied". Then I went into Control Panel and deleted every thing "SQL Server". Now I...

I think it is great to bring this to the attention of the community. This behavior cannot be tolerated.

Better than talking about it, I would love to see action....

Stefan Krzywicki (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

jcrawf02 (9/6/2012)

---

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Why do people think that they will get a different answer to the same problem if they post it...

Lynn Pettis (9/6/2012)

---

SQLRNNR (9/6/2012)

---

What is...

That user is being used in a connection string somewhere. It could also be in use by somebody who knows the pw to that account. Check to see...

jcrawf02 (9/6/2012)

---

SQLRNNR (9/6/2012)

---

What is the...

What is the circle of...

stupid language - always some silly rule:-D

Lynn Pettis (9/6/2012)

---

Jan Van der Eecken (9/6/2012)

---

RBarryYoung (9/6/2012)

---

Stefan Krzywicki (9/5/2012)

---

"Root" is...

Thanks Ron.

Yeah and that was a terrible result.

Thanks for a good question wayne