跨DB Server创建View

exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

create  view   TestView
  as
  select  *  from  openrowset('sqloledb','协议:IP或者Host,端口';'用户名';'密码',[DB Name].[Scheme Name].[Table Name])

例如：

openrowset('sqloledb','tcp:192.168.1.3,1433';'sa';'123456',[DB].[dbo].[DataTable])

posted on 2018-02-24 09:24 Zhe.Song 阅读(215) 评论(0) 编辑收藏举报