MSSQL中設定連結伺服器(Linked Server)

電腦小知識

–show link server

EXEC sp_linkedservers

–add link server

EXEC sp_addlinkedserver ‘DATA02′,",’SQLOLEDB’,’DATA02′

–undo sp_addlinkedserver

EXEC sp_dropserver ‘DATA02’, ‘droplogins’

, , ,