MSFT does not ship the store procedure to move the logins from one SQL Server instance to another. However, the steps has been describe in the KB 918992 here http://support.microsoft.com/kb/918992.
The store procedure is call sp_help_revlogin.
The steps describes in the KB article will create 2 store procedure. sp_hexadecimal and sp_help_revlogin.
sp_hexadecimal is used to convert numeric value to hexadecimal. It is called inside sp_help_revlogin.
Here is the result what it will looks like after you run the store procedure.
Richard Fryar has wrote the powershell script to achieve the similar purpose. You can find here http://www.sql-server-pro.com/sp_help_revlogin-alternative.html
Personally, I have not use any of above procedure myself. The environment I work with has already have similar script in place.
Reference
- How to transfer logins and passwords between instances of SQL Server http://support.microsoft.com/kb/246133 --> MSSQL 2005,2008
- sp_help_revlogin Alternative http://www.sql-server-pro.com/sp_help_revlogin-alternative.html
- How to transfer logins and passwords between instances of SQL Server http://support.microsoft.com/kb/246133 MSSQL 2000,2005
0 comments:
Post a Comment