george sibbald (4/10/2014)
Jake, the sp_help_revlogin will bring passwords across. straight to 2008. I have done it myself many times.Perry, master.sys.sql_logins is not available in SQL2000 so Jake will not be able to reverse engineer his login details with your script.
Worked great, thanks!!