Post reply

Login information

  • February 22, 2012 at 8:26 am

    #256210

    can any one tell me is there any possible in sql server to find "past date" login deatils of users to the databases.

    We want to check the list of users who have accessed the database for a particular time frame(PAST TIME).

    Note:We have not enable any trace .

  • February 22, 2012 at 8:33 am

    #1450358

    unless you already have created a trace which is capturing that information, it's not available anywhere. SQL server does not keep track of successful logins unless you enabled it or create a trace specifically for that.

    you can add one to start capturing that information in the future, but that's it.

    one long shot for you.....

    double check this screen. if you are lucky, someone may have enabled something other than the default of "Failed logins"

    if that is true, then you could see the logins in the error log:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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