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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-03-17 : 17:42:35
|
| Hi,I am migrating (on same machine side by side) from sql server 2000 (default) to 2005 (named instance) and have some linked server in 2000. Please let me know how to move to 20005.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-03-18 : 18:21:38
|
| Nos is not matter. I did not see any option in sql server 2005 management studio to create remote server. In sql server 2000 undrer linked servers tab there is one option to create remote server, in 2005 I dont' know how to create remote server. I upgraded sql server 2000 to 2005 side by side and moved objects. Now only remote server left. Please let me know how to create remote server in 2005.Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Linked Servers