link_server过了,代码如下
sp_addlinkedserver @server='servername', @srvproduct='',
@provider='SQLOLEDB', @datasrc='dnsname'
然后
CREATE VIEW PartitionedView AS
SELECT *
FROM server1.databasename.dbo.tablename
UNION ALL
SELECT *
FROM server2.databasename.dbo.tablename