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 |
|
sumwanlah
Starting Member
43 Posts |
 Posted - 2001-05-21 : 22:48:39
|
Hey Hey!I'm looking for a way to remove old STANDARD user logins. For NT logins, it's easy to remove them, cos there's the sp_validatelogins stored procedure, which will of course help to identify those NT accounts fresh for the 'kill'!I'm like taking care of 5 SQL servers, and over a hundred databases! There's a great deal of standard logins that have long since expired their use. Of course, the problem is which ones are no longer in use, and can be removed!At least if there isn't a script that someone has written that allows me to hunt down for these poor orphans, someone must have a script that can tell me the last time any standard login was used by anyone.10Q in ADV!  |
|
|
|
|
|
Removing old STANDARD user logins