exec sp_dropserver 'srv_lnk','droplogins'

go

exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','yarkool'

exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','123456'

go

--查询示例

--select * from srv_lnk.test.dbo.Sys_Menu

--导入示例

--select * into Sys_Menu from srv_lnk.test.dbo.Sys_Menu

insert into dbo.Sys_Menu select ItemName,Url,ParentID,SortID,CreateDate,ClassName from srv_lnk.test.dbo.Sys_Menu