Is this even possible?

When trying to insert data using the query below into a partitioned
view that is on a linked server, I get the following error:


'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]]. [SQLSTATE 01000] (Error 7300).  The step
failed.


Query:
INSERT INTO [SERVERNAME\INSTANCE].[DATABASE].[dbo].[VIEW]
select * from dbo.LOCALTABLE


I can select from the linked server's Partitioned View without any
problem.


Thanks

NEWSEQUINTIALID()
Slow Stored Procedure Execution
Join Question
how to specify a dynamic create string as backup name in job
Interesting Question