Which View Shows Domain Accounts?

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  July 22, 2009 at 9:18 am

  #207210

  Hi folks,

  I'm digging for information for the auditors.

  In 2005, *local* logins are stored in master's sys.sql_logins, but domain accounts are not in that view.

  Which table/view contains the logins for domain accounts?

  Thanks! John

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  July 22, 2009 at 9:24 am

  #1028408

  SELECT * FROM sys.server_principals

  WHERE type IN ('U', 'G')

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  July 22, 2009 at 9:49 am

  #1028454

  Perfect, Ten Centuries. This is exactly what I needed! We do have to keep those auditors happy 🙂

  Thanks very much. John