Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GavinS
Starting Member
14 Posts |
 Posted - 2006-05-23 : 04:10:06
|
| I have been asked at work if SQL Server can log access from users. For example if I was asked to say who had logged onto a certain database over the last few days would I be able to present a complete report of logging in and logging out for who and when?I know of logging in errors being reported in the SQL Server logs but I am pretty sure what is asked above is not possible to produce.Can anyone confirm this for me?Gavin (SQL Server DBA and Analyst for 1 year) |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-23 : 05:02:24
|
| right click on server in EM, properties, security, audit levelthe entries can be viewed at the sql log files, verify if that is what you are looking for...HTH--------------------keeping it simple... |
 |
|
|
GavinS
Starting Member
14 Posts |
Posted - 2006-05-23 : 05:34:47
|
| Thanks, this helps a lot and logs users at server level. Do you know if I can report on log ins at database level? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-23 : 05:52:03
|
| sorry, haven't found any need before so I haven't encountered it...probably logging the sysprocesses content into an admin table scheduled every minute or so...which is what other 3rd party tools are doing anyways, querying through the systables and scheduling this query--------------------keeping it simple... |
|
|
|
GavinS
Starting Member
14 Posts |
Posted - 2006-05-23 : 07:11:39
|
| Thanks Jen. I have set up this query and scheduled it. |
|
|
|
|
|
|
Log In Reporting in SQL Server 2000