Perhaps the easiest way is to use Object Explorer in Management Studio
- Connect to your database
- In Security / Logins branch select the login you want and open the context menu
- Select Script login as / Create to / New query editor
- Expand the database you use
- In your database select Security / Users
- and again Script the user
If you need to use a script to transfer login, you can find one for example at
Script All Logins / Users / and Roles - SQLServerCentral[
^]
Submit an article or tip