Hi ,
My requirement is to read and write the data from remote SQL SERVER.
Locally i have SQL SERVER and i want read and write the data from remote SQL SERVER.
I am able to read the data from remote SQL SERVER but i am getting the following error while inserting.
I created one linked server in my machine and mentioned the remote server name as data source.
The query is :
INSERT INTO OPENQUERY(DPVNEWLINK1, 'SELECT * from hyi3w131.SQLDPV.dbo.SAMPLEHAF') values(11,12);
The error is:
Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "DPVNEWLINK1" supplied inconsistent metadata for a column. The column "ROWID" (compile-time ordinal 1) of object "SELECT * from hyi3w131.SQLDPV.dbo.SAMPLEHAF" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.
Please suggest me regarding this.
Thanks in Advance,
Hafeez.