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?
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!