sql 创建链接服务器

exec sp_droplinkedsrvlogin [SXH121],NULL
exec sp_dropserver [sxh121]

exec sp_addlinkedserver
@server='SXH121',
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='120.197.84.11,3134'

exec sp_addlinkedsrvlogin
'SXH121',
'false',
NULL,
'username',
'pswd'

select * from SXH121.StreamMedia.dbo.Catalog

posted @ 2012-03-28 10:07  顿金  阅读(105)  评论(0编辑  收藏  举报