Post reply

insert using linked server / openquery

  • October 15, 2009 at 3:00 pm

    #139543

    I want to copy a table from SQL Server to linked server, have tried couple of ways but not working: -

    insert into OPENQUERY (SPA03LS, 'select * from ref_tbls..T_TEST')

    select * from cash..T_TEST

    go

    SELECT *

    INTO SPA03LS.ref_tbls..T_TEST

    FROM cash..T_TEST

    go

    Can someone help?

    Thanks,

    Nina

  • October 15, 2009 at 3:05 pm

    #1066554

    Hi,

    Would this work?

    insert SPA03LS.ref_tbls..T_TEST

    SELECT * FROM cash..T_TEST

    Regards

    Piotr

    ...and your only reply is slàinte mhath

  • October 15, 2009 at 6:31 pm

    #1066647

    Sorry, it did not.

    Msg 7314, Level 16, State 1, Line 1

    The OLE DB provider "MSDASQL" for linked server "SPA03LS" does not contain the table "ref_tbls.T_TEST". The table either does not exist or the current user does not have permissions on that table.

    Any other suggestions? Do appreciate your time and help.

    Thanks,

    Nina

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply