Results 1 to 2 of 2

Thread: Sql 6.5

  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: Sql 6.5

    I have to insert a record from a SQL 2000 into a remote SQL 6.5 server,
    what is the best way to do this?
    jaraba

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The "best" way is the first one that works. I'd suggest creating a linked server and doing the INSERT using a four part name from your Transact-SQL script or procedure.

    -PatP

Posting Permissions

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