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 |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2008-01-17 : 05:58:44
|
| Guys, How can we copy login (existing login will replace password) in SQL 2005? In SQL 2000, i can copy the password hash then update the sysxlogin table. as that table doesn't exists in SQL 2005 anymore, and using the SSIS transfer login task might not do what i wanted as i need to copy most of the login but not all (i know we can select from the list, but its not dynamic). As you can guess, this is for copying production login to BCP login and keep them in sync, how do you guys do it for 2005 now? |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-18 : 17:45:09
|
| Get the stored procedure sp_help_revlogin and this generate a list for you run this on your SQL 2000 it creates a list of logins, Then go into SQL 2005 and run the output. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-18 : 17:47:08
|
| But you have run a cursor sp_change_users_login to solve the roles and permissions. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-19 : 20:53:40
|
| Don't have to if you copy over sid at same time. |
|
|
|
|
|
|
Copy Login