If your organization has the kind of revolving-door staff turnover that many businesses are facing, you create new logins frequently. So how do you create a new SQL Server login that has the same permissions as an existing login? Each time you create a new SQL Server login that mirrors the permissions of an existing login, you probably go through a manual process in Enterprise Manager of reviewing the existing login's permissions, then granting the appropriate SQL Server access to the new login. This manual analysis and creation process can be tedious and error-prone. Have you ever considered auto-mating this administrative function?

I s...