創建鏈接服務器
創建:
EXEC sp_addlinkedserver 'yins02'
e.g:
SELECT * FROM [yins02].yins.dbo.t_brdl_manu_basc
刪除:
EXEC sp_dropserver 'yins02'
EXEC sp_addlinkedserver 'yins02'
e.g:
SELECT * FROM [yins02].yins.dbo.t_brdl_manu_basc
刪除:
EXEC sp_dropserver 'yins02'