Try:
SELECT *
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=MyServe;UID=sa;PWD=2001',
mks.dbo.Meeting) AS a
SELECT *
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=MyServe;UID=sa;PWD=2001',
mks.dbo.Meeting) AS a
('SQLOLEDB',
'Server=anderer_server;database=Northwind;TRUSTED_CONNECTION=YES;',
'SELECT * FROM northwind.dbo.orders') ??
exec sp_addlinkedsrvlogin @rmtsrvname='别名',@useself='false',@locallogin='sa',@rmtuser='sa',@rmtpassword='密码'
GO
然后如下试试:
select * from 别名.库名.dbo.表名select * from 别名.库名.dbo.表名 where 1=2
...
执行一下就可以了。