SQL-AddLinkserver

select * from sys.servers (查看目前多少可連線server)

--建server

exec sp_addlinkedserver 'Trovta', '', 'SQLOLEDB','IP' ;

exec sp_addlinkedsrvlogin 'Trovta', 'false',null, 'account', 'pass';

go

select * FROM openquery(Trovta, 'SELECT * FROM DBName.sys.TableName') ;

--刪server

Exec sp_droplinkedsrvlogin 'Trovta',Null ;

Exec sp_dropserver 'Trovta';