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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-27 : 07:58:00
|
| Sanjay writes "Hi,Is there any way to find out, the dormant (inactive) logins in SQL Server 7/2000. I want a list of all logins which were not logged in SQL Server for the last 30 days. Is this possible in SQL Server? If yes, please let me know.Can I configure "password expriation" (I was unable to find this parameter in sysconfigure table), for example, I want all SQL logins to change their password after 30 days. Please let me know the above answers.thanks in advance.Regards,Sanjay." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-27 : 12:30:41
|
| The last_batch column in sysprocesses will be able to tell you when the last time that they ran a query. There is no password expiration option. You will have to handle this through an application. Tara |
 |
|
|
|
|
|
Dropping Dormant Logins