how to delete rows using linked server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hafeez
    New Member
    • Sep 2006
    • 4

    how to delete rows using linked server

    Hi,
    I have two mssql databases. I am able to create a linked server.
    I want to delete some of the rows using this linked server.

    Here HAFEEZ is one mssql database and DPVSQSL is another.So, i want to delete rows from DPVSQL from HAFEEZ using HAFEEZDPVSQL linkedserver.

    DELETE OPENQUERY (HAFEEZTODPVSQL , 'SELECT EVENT_SYS_ID FROM DIS_MEASMT_FTR_ ACTUAL WHERE EVENT_SYS_ID = ''evesysid0015' '');

    when i run the query i got the following error.

    "Msg 7356, Level 16, State 1, Line 1
    The OLE DB provider "SQLNCLI" for linked server "HAFEEZTODPVSQL " supplied inconsistent metadata for a column. The column "EVENT_SYS_ ID" (compile-time ordinal 1) of object "SELECT EVENT_SYS_ID FROM DIS_MEASMT_FTR_ ACTUAL WHERE EVENT_SYS_ID = 'evesysid0015'" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time."

    Please note that i am able to query something using this linked server,please see the below query.

    SELECT * FROM OPENQUERY (HAFEEZTODPVSQL , 'SELECT EVENT_SYS_ID FROM DIS_MEASMT_FTR_ ACTUAL WHERE EVENT_SYS_ID = ''evesysid0015' '');

    Can anyone please help me regarding this.

    Thanks and Regards,
    Hafeez.
Working...