Using multiple servers in a query

  • Heads Up

    Be aware of performance when using a "linked server". It's not very efficient, especially if you're running transactions, such as INSERT/UPDATE/DELETE, between the servers. If you are running the DML, then DTC will be used and you may need certain ports opened through your network.

    Definitely avoid something like:

    INSERT INTO mytable exec [linkedserver].[dbname].[owner].[sproc]

    This will take forever and you may encounter DTC issues. You'll want to use other techniques.

    Just some info.

    Steve

  • Turns out my IT department was giving me the wrong linked server name. I am only using this to pull data - I don't need to manipulate it at all, so it shouldn't be an issue.

    Thank you to everyone!:-D

Viewing 2 posts - 16 through 16 (of 16 total)

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