SQL Server: Easiest way to copy users from dev -> prod
What is the easiest way to move (copy) users from dev database to prod database?
Select the "Users" node in Object Explorer, Bring up "Object Explorer Details" from the View menu. Select all, Right Click, "Script User as..."
Review script and change any logins as required to refer to logins on the production server.