NO, the script will create 2 store procs on your master db

step1: create proc's on destination server

step2: exec sp_help_revlogin in destination server

save the result set in some where(create login script is the result set)

step3: take the backup on source server

step4: restore on the destination server

step5: run the login script on destination server(result set of sp_help_revlogin)

note: when you restore the db source server users will over write on the destinaton database, we have to resync the logins. so, thats why we are taking logins script with sid valuve & encrypted PW