Post reply

User creation date

  • 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

  • February 9, 2010 at 12:21 am

    #1115947

    have you checked these 2 tables?

    select * from sys.database_principals

    select * from sys.server_principals

  • 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]

  • February 9, 2010 at 5:02 pm

    #1116470

    Thanks very much for your help.

    I have the information now.

    Kind Regards

    Mark

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply