Unable to synchornize navision user with SQL

nikeman77

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 ?

nikeman77

:thumbsup:
Step1:

Grant DB_Owner

Step2:

http://dynamicsuser.net/forums/p/64601/342934.aspx#342934