SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

Handy Articles

 

https://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx

How to transfer logins and passwords between instances of SQL Server

How to transfer logins and passwords from SQL Server 7.0 to SQL Server 2000 or between servers that are running SQL Server 2000

To transfer logins and passwords from a SQL Server 7.0 server to an instance of SQL Server 2000, or between two instances of SQL Server 2000, you can use the new DTS Package Transfer Logins Task in SQL Server 2000. To do this, follow these steps:
http://support.microsoft.com/kb/246133/

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

Run EXEC sp_help_revlogin
The output script that is generated by the sp_help_revlogin stored procedure is the login script. This login script creates the logins that have the original Security Identifier (SID) and the original password.
http://support.microsoft.com/kb/918992

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>