Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • 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?
0
valkyrie_nc
Asked:
valkyrie_nc
  • 2
1 Solution
 
Larissa TCommented:
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:
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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