• I hadn't seen your post when I wrote the blog entry, so it's a nice coincidence. If you want to get everything in one query, you can query the sysusers and syslogins tables directly with a join.

    Determining if it's a SQL login, Windows Login, or Windows group

    K. Brian Kelley
    @kbriankelley