Unable to synchornize navision user with SQL

nikeman77nikeman77 Member Posts: 517
edited 2013-05-24 in SQL General
Hi all,

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 ?


Sign In or Register to comment.