I am trying to automate SQL Login transfer from SQL2000 to SQL2005.
The SQL2000 database is restored onto SQL2005 server every night.
Once the db is restored, the db users will be orphaned.
The following KB tells you how to transfer login with password but it doesn't seem to restore database mapping and its permission.
Any help will be appreciated.