Linked server cannot use insert?
Hi.
MSSQL , I have and sp that do this:
INSERT INTO VM.dbo.tblClient
...bla
When I change it to a new linked server , like:
INSERT INTO HOSRV.VM.dbo.tblClient
I get:
Column name or number of supplied values does not match table definition.
The server is a 1-1 copy so the columns are the same , so I don't have a clue. Delete and Update changes I made did not complain.
Thanks.
Re: Linked server cannot use insert?
Something is most likely different in the table definition. Pay attention to the datatypes and column order, and find what is off. Replace any '*' with the actual column names you expect to send over.