Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2008-01-23 : 11:35:05
|
| My database is being moved from SQL 2000 to SQL 2005. Is there a way to copy a User from the old database to the new one, call it a different name and let it have all the same rights as the old one. |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-23 : 15:33:36
|
| Get this procedure sp_help_revlogin and put in master on your SQL 2000 then run it it produces a list of logins, then on SQL 2005 just run it creates all logins for you.Not sure if you can rename the login you have to try doing it with the script. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-23 : 22:34:29
|
| Db users are moved with db, you can remap them to sql logins on sql2k5 with sp_chage_users_login. |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2008-01-24 : 06:11:46
|
| Thx |
|
|
|
|
|
|
Users