CONECTANDO 2 SQL 2000

Relacion de Servidores Linkeados
=======================
select * from master..sysservers

Linkear con Codigo
==============
EXEC sp_addlinkedserver
@server = ’server_remoto’ ,@srvproduct = ‘Mi Sistema’,
@provider = ‘MSDASQL’,
@provstr = ‘DRIVER={SQL Server};SERVER=192.168.1.33;UID=sa;PWD=misuperclave;’

Aparece un nuevo server
=================
select * from master..sysservers

Elimina Servidor y sus conexiones activas
===============================
sp_dropserver ’server_remoto’, ‘droplogins’

Luego consultas una Tabla
====================
select * from server_remoto.pubs.dbo.authors

Tambien se puede conectar a otros formatos
==================================

ACCESS:
EXEC sp_addlinkedserver @server = ‘SEATTLE Mktg’, @provider = ‘Microsoft.Jet.OLEDB.4.0′, srvproduct = ‘OLE DB Provider for Jet’, @datasrc = ‘C:\MSOffice\Access\Samples\Northwind.mdb’

XLS:
EXEC sp_addlinkedserver ‘ExcelSource’, ‘Jet 4.0′, ‘Microsoft.Jet.OLEDB.4.0′, ‘c:\MyDataDistExcl.xls’, NULL, ‘Excel 5.0′

DBF:
EXEC sp_addlinkedserver ‘EJ‘,‘Jet 4.0′,‘Microsoft.Jet.OLEDB.4.0′,‘c:\real\concar80′,NULL,‘dBase IV’
ejecutando select vinculado
SELECT * FROM [EJ]…ccd0407 where dsubdia=’23′ and left(dcompro,2)=’09′