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 |
|
Kitkens
Starting Member
2 Posts |
 Posted - 2014-06-18 : 13:33:55
|
| Hello All,Is there a way to find inactive (people who have not logged in in the past year - for example) users and logins in the server without enabling auditing?Thanks!Linda |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-18 : 14:35:54
|
| You need to audit in some way as SQL Server does not track it. You could setup a small job that checks sysprocesses and logs last active time for each user, so only one row per login would be needed.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Finding inactive users/logins