about distributed partition view | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

about distributed partition view

I created table aa1 in sql server host a©s
create table aa1 (factory_code varchar(4),ymday varchar(10),qty int
constraint pk_aa1 primary key (factory_code,ymday),
constraint ck_aa1 check (factory_code=’312′ ),
constraint ck_aa1_2 check (ymday between ‘2003/07/01’ and ‘2003/07/30’)
) Created table aa2 sql server host b(the database’s name is TEST)©s
create table aa2 (factory_code varchar(4),ymday varchar(10),qty int
constraint pk_aa2 primary key (factory_code,ymday),
constraint ck_aa2 check (factory_code=’311′ ),
constraint ck_aa2_2 check (ymday between ‘2003/07/01’ and ‘2003/07/30’)
) 3.created a link server in sql server b,the link server’s is TEST. 4.create a view in host a:
create vies r_aa as
select * from aa1
union all
select * from test.test.dbo.aa2 I can select all rows from this view,but I can’t insert or update any data into it.
The error message means OLE DB Provider ‘SQLOLEDB’ can’t suports distributed transactiion. Any suggestion??? Thanks!
Jelly.
Are you using the latest version of MDAC? What are the versions and service packs of SQL Server? In the mean time have a look at
http://dbforums.com/arch/30/2003/2/691133 Gaurav
Many hanks for Gaurav’s help.
I using MDAC2.6 and SQL Server service packs 3.
and the service of MSDTC is running.
Jelly.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |