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

Did you try the sdame thing wiht select * from
OPENQUERY(Servername,'Sql statement')

Maninder
MCDBA

Are you suggesting I use that to create the view with? So the view is
on the local server. Otherwise I don't see how that helps as I am
selecting from local tables and inserting into a view on another
server.

Dan