Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Location
    Bordentown, NJ
    Posts
    27

    Unanswered: SQL 2005 - Who created the login?

    What system table can I query to determine which user-id created a particular login?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    god

    and this message is to short
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sorry Bordentowm

    Look at sysuers

    But I don't think the brilliant minds at M$ figured on that

    It's more about you having control

    I guess the assum sa grants everything
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by ckintner
    What system table can I query to determine which user-id created a particular login?
    SQL Server 2005 has a default trace that logs certain actions (such as CREATE LOGIN). Depending on how long ago the login was created, you might be able to pull the information using the following:

    SELECT TargetLoginName, SessionLoginName, HostName, StartTime
    FROM fn_trace_gettable('<X>:\<install dir>\LOG\log_###.trc', default);
    GO

    Regards,

    hmscott
    Last edited by hmscott; 12-11-08 at 20:30.
    Have you hugged your backup today?

  5. #5
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    select * from ::fn_trace_getinfo(0) - this provide the details about the traces running in SQL , SQL server has C2 audit present it , Try analysing that trace

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •