I would like to transfer user from LIVe database to test database(both using sql 2008), so i run sp_revlogin to export out users from LIVE.
test database have existing user in sql already (the user lists was updated 2010).
NOTE: I am not SQL trained… [:(]
Few questions I am not sure.
1.Do I need to delete all existing user in test database? where can I find the script to do that?
2.After which I delete do i just copy the text file exporting from sp_revlogin and execute it ?
3.Any requirement to synchronize navision after that ?
4.What other steps is needed ?