Post reply

When sql account was created?

  • March 25, 2009 at 10:49 am

    #384208

    How can i find when and who created a sql account on the production server.

    I have no clue who created that and for what purpose.

    thanks

  • March 25, 2009 at 10:54 am

    #966121

    select * from master..syslogins

    :crazy: :alien:

    Umar Iqbal

  • March 25, 2009 at 11:06 am

    #966131

    I dont have information on who created that account, i just have created date.

  • March 25, 2009 at 11:09 am

    #966133

    If you are on SQL 2005 then you can look at the default trace to see who created the login.

  • March 25, 2009 at 11:11 am

    #966135

    It was created someitm in mid 2008 and i dont think i will have traces for that long.

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

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