November 27, 2008 at 3:01 am
Hi All
I need help, i need to do a clean in my sql servers. how to drop Logins that haven't logged in for 6 months?
Thanks in advance!!
It's better to fail while trying, rather than fail without trying!!!
November 27, 2008 at 3:22 am
The dificult part is to find the information when a login was last used. Unless you have enabled login auditing for succesfuly logins that information is not automatically stored. You can also create a login trigger which logs the information in a table, this option was introduced in SP2.
If you alread know which logins have not been used for a long time simply use DROP LOGIN myLogin to remove them. In case you're not sure you can first disable them using ALTER LOGIN myLogin DISABLE.
[font="Verdana"]Markus Bohse[/font]
November 27, 2008 at 3:31 am
Thanks for your response.
My sql server security propeties is set to audit both failed and successful logins. What about syslogins?
It's better to fail while trying, rather than fail without trying!!!
November 27, 2008 at 3:42 am
what do you mean with syslogins? The table syslogins doesn't have information about the last time a login was used. If you're talking about the logins which are automatically created during installation, leave them. SQL Server needs them for certain tasks.
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply