How to transfer the logins and the passwords between instances of SQL Server
To transfer the logins and the passwords from the instance of SQL Server on server A to the instance of SQL Server on server B, follow these steps:
1. On server A, start SQL Server Management Studio, and then connect to the instance of SQL Server from which you moved the database.
2. Open a new Query Editor window, and then run the following scriptUSE masterGOIF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP P
Leggi tutto il post...