Post reply

How to get historys of users login in sql server 2008

  • October 18, 2011 at 3:17 am

    #249661

    Hi all

    How to get historys of users login in sql server 2008

    user login time and log off time

    Thanks in advance

  • October 18, 2011 at 3:47 am

    #1395755

    Set login auditing to failed and successful logins. You can then get login information from the errorlog. If you want logout information as well, the only way I know is to run a trace.

    John

  • October 18, 2011 at 6:32 am

    #1395860

    Thank you very much

    Is there any SP in SQL to store these infomations , without using login auditing .

  • October 18, 2011 at 6:36 am

    #1395863

    Yes, there are stored procedures you can use to set up a server-side trace.

    John

  • October 18, 2011 at 6:39 am

    #1395868

    I preffer a trace for this.

    Error logs are for errors (in my preference). I don't like parsing 1 gazillion succesful logins to get to the 1-2 errors I need to know about.

    Yes this can be scripted but you have to wait on drives & I still preffer to have the correct data in the correct "table". 😉

  • October 18, 2011 at 6:41 am

    #1395870

    Hi , if we enable the trace in server side It will affect the performance,

    So can you plz tell me is there any inbuilt SP in msdb to show these information.

    Thanks in advance

    🙂

  • October 18, 2011 at 6:44 am

    #1395871

    trarunprasanna (10/18/2011)

    if we enable the trace in server side It will affect the performance

    Will it? How do you know that whatever other solution that may exist doesn't affect performance even more?

    John

  • October 18, 2011 at 6:51 am

    #1395877

    ok , i'll try the trace in the server ,plz let me know the Procedure and steps the inplement the in the server

    Thank you

  • October 18, 2011 at 6:55 am

    #1395882

    If scripted, this won't affect perf at all.

    http://qa.sqlservercentral.com/stairway/72363/

  • October 18, 2011 at 6:55 am

    #1395883

    Try one of these links and let us know how you get on.

    John

  • October 18, 2011 at 7:03 am

    #1395890

    Thank you very much

  • October 18, 2011 at 7:03 am

    #1395892

    ya sure

    Thank you very much

  • October 18, 2011 at 7:06 am

    #1395893

    trarunprasanna (10/18/2011)

    ya sure

    Thank you very much

    We have a lot of people with "plz do my work for me" type of question.

    The let me google that for you answer pops up once in a while out of accumulation.

    Let's assume it's not your fault this time :-D.

    Let me know if you need more help with the trace after you've read the articles and get blocked somewhere.

  • October 18, 2011 at 7:31 am

    #1395919

    Thank you , i'll follow those things

Viewing 14 posts - 1 through 13 (of 13 total)

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