470,822 Members | 1,194 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,822 developers. It's quick & easy.

getting problem while inserting using linked server

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 :


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,
Sep 26 '06 #1
0 1975

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

303 posts views Thread by mike420 | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.