Is there a way to directly copy the User Mapping from one SQL Server login to another using SQLCMD?
In SQL Server Management Studio Object Explorer | (local) | Security | Logins, Right-Click a user (e.g: BUILTIN\Administrators | User Mapping, I'm looking for a way to copy all the related information in that window from one account to a newly created one.
The main reason I need to use SQLCMD is I'm looking to place this in a script.