July 24, 2002 at 8:04 am
Good morning everybody,
OK, today I a have a question, in sql2000, I exported the user names from one data base to another one in different servers, generating and running a script, OK, now I have in the destiny data base the users already, but I don't have the passwords, is there a way to export the passwords too??? or do I have to enter again the passwords???
thanx a lot, have a nice day
L.I. Amaury C.R.
July 24, 2002 at 8:39 am
Passwords are stored in sysxlogins, you can move them using DTS in SQL2K, do an update query using a linked server, or there is a feature of sp_addlogin that will you pass the encrypted password as well.
Andy
July 24, 2002 at 12:05 pm
Ok Andy, thanks a lot because of your help, you are very kind, let me do it, if I have a question, I'll bother again...
bye
L.I. Amaury C.R.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply