Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13

    Unanswered: DML by Linked Servers

    Hi,

    I have two SQL-Server 2000 servers - SERVERDB01 and SERVERDB02.
    I made a linked server from SERVERDB01 to SERVERDB02.

    This instruction is ok.
    SELECT * FROM openquery (SERVERDB02,'select * from dbacdl.aux_data')

    I need execute DML commands by Linked Servers.
    i.e. -> truncate dbacdl.aux_data or delete dbacdl.aux_data

    How can I do?

    Thank you by attention.

    Bye.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    how about issuing the truncate or delete using the four part nameing convention?

    <Server Name>.<Database Name>.<Owner Name>.<Object Name>
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13
    Paul Young,

    thank you by the answer, but It did wrong.

    I was in the SERVERDB01
    TRUNCATE TABLE SERVERDB02.SICDB.DBACDL.AUX_DATA

    This mensage appear:
    The object name 'SERVERDB02.SICDB.DBACDL.' contains more than the maximum number of prefixes. The maximum is 2.

    I did some mistake, maybe.

    Bye.

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    No, I answqered your question a little to fast. Truncate won't work but delete will, try again using delete rather than truncate.
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13

    Talking

    Paul Young ,

    It's ok.

    thank you very much.

    Bye.

Posting Permissions

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