-
Inserting data into a partitioned view via Linked Server
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
-
Re: Inserting data into a partitioned view via Linked Server
Does anyone know this?
SGCSNA wrote:
> 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