• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

Is there a way to copy a linked server from SQL 2000 to SQL 2008?

Is there any way to copy a linked server from an instance of SQL 2000 Server to SQL 2008 Server?  I'm having a hard time finding the authentication information for this super-old connection but we do need it, so I'm hoping I can script it out.

If that won't work, is it possible to access a linked server through a linked server?  i.e., if I were to have the SQL 2000 server on there as a linked server, could I then access its linked server?
  • 2
1 Solution
Lara FEACommented:
try to create procedure on server that has old linked server credential, that will perform query you need.
then you can link this server to your new server and call this procedure.
Scott PletcherSenior DBACommented:
Scott PletcherSenior DBACommented:
You could also look at table: sysservers

and at the code for MS procs:
They should point you to other system tables if needed :-) .
valkyrie_ncAuthor Commented:
Perfect!  Does exactly what I need.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now