Automate the transfer of standard logins from one server to another with the passwords

				
--**************************************
-- Name: Automate the transfer of standard logins from one server to another with the passwords
-- Description:A script to automate the transfer of standard logins from one server to another with the passwords. This one uses a distributed query against the source server.
-- By: Umachandar
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=143&lngWId=5--for details.--**************************************

-- Setup a linked server called impserver from which the
-- standard logins needs to be transferred. You can call it
-- whatever you want & modify the linked server name also.
declare @login sysname , @password sysname 
declare implogins cursor for 
 select name , password 
 from impserver.master.dbo.syslogins 
 where isntname = 0 and charindex( 'repl_' , name ) = 0 and 
charindex( 'distributor' , name ) = 0 and name != 'sa' 
open implogins 
while ( 'FETCH IS OK' = 'FETCH IS OK' ) 
begin 
 fetch implogins into @login , @password 
 if @@fetch_status < 0 break 
 exec sp_addlogin @login , @password , @encryptopt = 'skip_encryption'
end 
deallocate implogins 
go