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 |
|
Maxer
Yak Posting Veteran
51 Posts |
 Posted - 2007-06-25 : 15:52:00
|
| I have SQL Server 2005 on a DEV box and I have a linked server on that box.It has several logins that I would like to move over to our production server when I re-create the linked server.Now I can export the script to create that linked server, but when I do so it doesn't provide me with the user's login password.Is there a way to export the password as part of the script so I can move the linked server AND all the users associated to it over to a new server? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-25 : 22:15:53
|
| Use ssis copy logins task. |
 |
|
|
|
|
|
How can I move logins for a linked server?