我想两台电脑做分布式分区试图请问我错在什么地方
--ServerA
use pubs
gocreate table customers
(
Customerid varchar(5) not null,
CompanyName varchar(50) not null,
ContactName varchar(30) NULL,
CONSTRAINT PK_customers PRIMARY KEY CLUSTERED (Customerid),
CONSTRAINT CK_customerid CHECK (customerid between 'AAAAA' and 'LZZZZ')
)exec sp_addlinkedserver
@server='27cf93f521cc488',
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='ServerB'
go
exec sp_addlinkedsrvlogin
@rmtsrvname ='27cf93f521cc488',
@useself ='false',
@rmtuser ='sa' ,
@rmtpassword =''
go--
Exec sp_serveroption '27cf93f521cc488','lazy schema validation','true'create view DPV_Customers As
Select * from Customers
Union all
Select * from 27cf93f521cc488.Pubs.dbo.Customers
--27cf93f521cc488 为另外一台局域网内电脑数据库的名称
--ServerA
use pubs
gocreate table customers
(
Customerid varchar(5) not null,
CompanyName varchar(50) not null,
ContactName varchar(30) NULL,
CONSTRAINT PK_customers PRIMARY KEY CLUSTERED (Customerid),
CONSTRAINT CK_customerid CHECK (customerid between 'AAAAA' and 'LZZZZ')
)exec sp_addlinkedserver
@server='27cf93f521cc488',
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='ServerB'
go
exec sp_addlinkedsrvlogin
@rmtsrvname ='27cf93f521cc488',
@useself ='false',
@rmtuser ='sa' ,
@rmtpassword =''
go--
Exec sp_serveroption '27cf93f521cc488','lazy schema validation','true'create view DPV_Customers As
Select * from Customers
Union all
Select * from 27cf93f521cc488.Pubs.dbo.Customers
--27cf93f521cc488 为另外一台局域网内电脑数据库的名称
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货