Updating Partitioned View Across Linked Server
- From: "Dan" <moro0012@xxxxxxxxx>
- Date: 30 Jan 2007 18:45:58 -0800
Greetings,
Using SQL Server 2000 SP4 64 bit edition, I am trying to update a
partitioned view on one server from another. Here are the
details.....
Server A (Where Insert Query Runs From):
insert into archiveLS.archive.DBO.archive_View
select * from #buffer (NOLOCK)
where recordnum > @vMaxRecordnum
Server B (Where Partitioned View Exists):
Create view archive_view as
select * from archive_view_Jan2007
union all
select * from archive_view_Feb2007
The base tables archive_view_Jan2007 and archive_view_Feb2007 have
matching schemas and both have check constraints that have been
validated based on date, and the previously mentioned date column is a
member of the primary key.
I am able to insert into the view when I run the insert statement on
the local server, but when I run it from the remote server using a
linked server, I get the following error.....
Server: Msg 7306, Level 16, State 2, Line 16
Could not open table '"archive"."DBO"."archive_View"' from OLE DB
provider 'SQLOLEDB'. The provider could not support an interface
required for the UPDATE/DELETE/INSERT statements. The provider
indicates that conflicts occurred with other properties or
requirements.
[OLE/DB provider returned message: Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No
work was done.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset
returned 0x80040e21: [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600
STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True
STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetChange VALUE=True
STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_UPDATABILITY VALUE=4
STATUS=DBPROPSTATUS_OK]].
Does anybody know of any issues regarding inserting into a partitioned
view remotely using a linked server? Any reply would be appreciated.
Thanks,
Dan
.
- Prev by Date: Re: large SP performance difference between identical servers
- Next by Date: SQL 2005 Express and VS .Net 2003 wizard error More options
- Previous by thread: LEFT JOIN Question
- Next by thread: SQL 2005 Express and VS .Net 2003 wizard error More options
- Index(es):
Relevant Pages
|
|
