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 |
|
Sqlbuddy
Starting Member
27 Posts |
 Posted - 2009-05-11 : 15:10:03
|
| Hi, I have linked servers on SS2000 instance? Could any one tell me how to migrate those linked servers to SS2005? Can we script the linked server on SS2000 instance using SSMS and then execute the script on SS2K5 instance? Thank you,YoursSQLBuddy |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-11 : 15:24:39
|
| Yes, you can script them out from SSMS and run them on the 2005 server/instance. If you are using explicit security credentials that you have to change the password, Management Studio will replace it with "###" characters. |
 |
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-05-11 : 15:52:48
|
| Hi Robvolk, Thank you very much. I really appreciate your help.Yours,SQLBuddy |
|
|
|
|
|
|
How to migrate linked servers from SS2000 to SS2K5