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

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

This is an absolutely excellent script which we can use to create a stored procedure: SP_HELP_REVLOGIN
to script all of our logins when moving databases to a new server or server instance.

And here is a similar document for older versions of SQL:

http://support.microsoft.com/kb/246133

Posted on 1:37 PM by Nathan aka Mysteryn11 and filed under , | 0 Comments »

0 comments: