Results 1 to 2 of 2

Thread: Linked server cannot use insert?

  1. #1

    Thread Starter
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    6,763

    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.
    ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
    πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·

  2. #2
    PowerPoster
    Join Date
    Aug 2005
    Location
    College Station, TX
    Posts
    4,521

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width