+ Reply to Thread
Results 1 to 2 of 2

Inserting data into a partitioned view via Linked Server

  1. 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


  2. 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



+ Reply to Thread