User creation date

• Mark Catlin

  SSC Enthusiast

  Points: 184

  More actions

  February 9, 2010 at 12:03 am

  #218935

  Hi

  I have an audit requirement to list users and their creation dates. I can't find this info anywhere on the GUI. Can someone please point me at the appropriate tables where I can query this information?

  I am assuming creation date is stored somewhere.

  Thanks

  Mark

• Leo Leong

  SSCommitted

  Points: 1615

  More actions

  February 9, 2010 at 12:21 am

  #1115947

  have you checked these 2 tables?

  select * from sys.database_principals

  select * from sys.server_principals

• wschampheleer

  SSCertifiable

  Points: 5504

  More actions

  February 9, 2010 at 12:24 am

  #1115948

  Open the Object Explorer Details window (F7) and click on Security - Logins in the Object Explorer pane.

  Regards,

  Willem
  http://wschampheleer.wordpress.com[/url]

• Mark Catlin

  SSC Enthusiast

  Points: 184

  More actions

  February 9, 2010 at 5:02 pm

  #1116470

  Thanks very much for your help.

  I have the information now.

  Kind Regards

  Mark