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?
LVL 9
valkyrie_ncAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
0
 
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.
0
 
Scott PletcherSenior DBACommented:
You could also look at table: sysservers

and at the code for MS procs:
sp_addlinkedserver
sp_addlinkedsrvlogin
They should point you to other system tables if needed :-) .
0
 
valkyrie_ncAuthor Commented:
Perfect!  Does exactly what I need.
0
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.

All Courses

From novice to tech pro — start learning today.