Post reply

Tracing users on db from the past...

  • June 13, 2007 at 9:37 am

    #120421

    Hi

    As a newbie to DBA type tasks, how can I trace who has accessed the server/database in the past (i.e. a month ago).

    I know there is a SPID in the Server log but what does this represent? Also, this is only for current connections.

    Thanks!

  • June 13, 2007 at 10:06 am

    #712668

    Unless you have logging enabled you probably can't.

    I'd go into your server properties and under login auditing set it to audit both successful and failed logins.

  • June 15, 2007 at 4:46 am

    #713198

    SPID keeps changing. An unallocated SPID used in past can be assigned to another user. Unless you have any moethods of logging enabled you will not able to track the users i db.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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