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.