October 18, 2011 at 3:17 am
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
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
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
Yes, there are stored procedures you can use to set up a server-side trace.
John
October 18, 2011 at 6:39 am
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
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
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
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
If scripted, this won't affect perf at all.
October 18, 2011 at 6:55 am
Try one of these links and let us know how you get on.
John
October 18, 2011 at 7:03 am
Thank you very much
October 18, 2011 at 7:03 am
ya sure
Thank you very much
October 18, 2011 at 7:06 am
trarunprasanna (10/18/2011)
ya sureThank 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
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