Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    7

    Unanswered: Linked server option ?

    Hi Everone,
    I'm new here so please bear with me. I'm not sure how to ask this question so I have not done a search yet.
    I have a proc that creates select statements on the fly from a feeder metadata table for ten tables at a time, all the time. Until now everything was on one server. Now some of the data tables are on another server, but this is not a problem.
    There are some times when one of the tables is missing and the proc throws an error (as it should) and stops the execution of the 9 table builds. When it was all on one server, it would always throw an error and continue. Now when it's reading through a linked server it will not continue.
    What can I do ? Thank you all.

    Ken

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Ken

    Some code would help here...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2004
    Posts
    7
    Hi Brett, Thanks for looking.
    The code kicks out 10 select statements and executes each one at a time. In some cases the tables the code is looking for do not exist and SQL throws an error. When I was on the original server (not selected through a linked server) the select would fail and move on to the next select statement (running a cursor). Now when the select fails because the tables don't exist on the linked server, the execution of the proc stops when it reaches the first error instead of moving on. I was hoping it was an option of some sort for the linked server.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Ensure to refer the Linked server information in the code in order to execute the query.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34

    Question

    Whats the proc code?

Posting Permissions

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