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 |
|
ChetShah
Starting Member
37 Posts |
 Posted - 2005-07-29 : 08:46:41
|
| Hi,Does anyone know of a script whereby they can migrate SQL Server Logins as well as database logins??Chet |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-07-29 : 14:44:35
|
| There is a DTS Task called "Transfer Logins Task". That's probably the simplest way to move the server logins. The database Users will be restored with the database if you are restoring a database although you may have to call sp_change_users_login to reassociate the user with login. (see BOL)If you aren't restoring a database...have you tried searching this site for the scripts, I bet they've been posted already.Be One with the OptimizerTG |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Migrating Logins