In order to add a linked SQL Server 2008 to SQL Server 2000, you may execute this query on SQL Server 2000: EXEC sp_addlinkedserver @server=' linked_server_name ', @srvproduct='', @provider='SQLOLEDB', @datasrc=' instance_name ' You only need to give
