跨服务器访问数据

原创于 2013-03-22 15:03:19 发布

· 818 阅读

0 ·

版权

MS SQL 专栏收录该内容

10 篇文章

订阅专栏

    
    SELECT  a.*
    FROM    OPENROWSET('SQLNCLI',
                       'Server=SAD-HL7DB8MR8CI\SQLEXPRESS;Trusted_Connection=no;uid=sa;pwd=123456;',
                       'select * from lawyerdb.dbo.lawyerlist') AS a
    
    SELECT  *
    FROM    OPENROWSET('SQLNCLI', 'SAD-HL7DB8MR8CI\SQLEXPRESS'; 'sa'; '123456',
                       lawyerdb.dbo.lawyerlist)
    
    EXEC sp_addlinkedserver 'srv_lnk', '', 'SQLNCLI', 'SAD-HL7DB8MR8CI\SQLEXPRESS'

    EXEC sp_addlinkedsrvlogin 'srv_lnk', 'false', NULL, 'sa', '123456'
	
    SELECT  *
    FROM    srv_lnk.lawyerdb.dbo.lawyerlist
	
    EXEC sp_dropserver 'srv_lnk', 'droplogins'

暂时只在本地测试通过！