All of our SQL is SQL 2000. Most the refreshes I do for development teams are straight forward. When I am done, I have a script that drops all logins/users and re-creates them.
I now have a development enviroment where that is not desireable.
How do I match up the logins and userids after a refresh so the password does not change in the development enviroment? This is a vendor/is driven combined application where the vendor has a user/pwd hard coded into the code.
thanks for any help