In my demoenvironment I juggle lots of SQL databases. Each database has lots of Users, which are linked to separate Security->Logins on the server.
Over time I keep ending up with many (like hundreds) of orphans Security->Logins that are not linked to any users in any of the databases.
Is there any SQL statements I can run to drop the unused Logins - i.e. the logins that have no mappings to database users?