From: web12master@gmail.com   
      
   Hello,   
      
   when there is need to transfer full backup from one server to another   
   server, there is usually need to transfer logins too.   
   backup contains users. So when we restore backup to another server, we have   
   our users in it.   
      
   Let say we have user1 in datebase1   
      
   Now we create login user1 and try to map that login to database1   
      
   But now we got error, something like 'User, group or role 'user1' already   
   exists in the current database ...'   
      
   So we need to delete user1 from database1 and then map it again.   
   Problem is if there is many objects depend on user1, we must break this   
   connection first, and then we can delete user1.   
      
   Is there any different way, remapping or somthing?   
   What to do in this case?   
      
   Regards   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)