Exec sp_droplinkedsrvlogin DBVIP,Null?????? --刪除映射(錄與鏈接服務器上遠程登錄之間的映射)

Exec sp_dropserver DBVIP???????????????????????? --刪除遠程服務器鏈接

EXEC? sp_addlinkedserver

@server='DBVIP',--被訪問的服務器別名

@srvproduct='',

@provider='SQLOLEDB',

@datasrc="/Server2"?? --要訪問的服務器

EXEC sp_addlinkedsrvlogin

'DBVIP', --被訪問的服務器別名

'false',

NULL,

'sa', --帳號

'thankyoubobby' --密碼

Select?? *?? from DBVIP.pubs.dbo.orders

/ORACLE

Exec sp_droplinkedsrvlogin demo,Null

Exec sp_dropserver demo

go

EXEC sp_addlinkedserver

@server ='demo',

@srvproduct='Oracle',

@provider='MSDAORA',

@datasrc="/ServiceName"

EXEC sp_addlinkedsrvlogin

'demo',

'false',

NULL,

'userid',

'password'

go

SELECT * FROM OPENQUERY(demo ,'select * from tbdemo' )

UPDATE OPENQUERY (demo, 'SELECT id FROM tbdemo WHERE id = 101')

SET name = 'hello';

INSERT OPENQUERY (demo, 'SELECT id FROM tbdemo')

S ('hello');

DELETE OPENQUERY (demo, 'SELECT id FROM tbdemo WHERE name = ''hello''');