• Before I transfer/copy/restore any database to another server I always use the following to generate sql to create login(s). This makes sure that the sid is the same so that all the user permissions tie up.

    select 'sp_addlogin '''+name+''',@sid=',sid from syslogins where name = 'username'

    Far away is close at hand in the images of elsewhere.
    Anon.