Post reply

How Do I insert into a table on linked server?

  • March 15, 2005 at 11:34 pm

    #66590

    I've tried to have a stored procedure call a procedure on server two, and it just hangs up SQL.

    The query funs fine in query analyzer. Has anyone done this, or is it better to create a trigger to update a table in a linked server? What's the best option here? I"ve never done anything like this before and could use help. Thank you.

  • March 16, 2005 at 2:36 am

    #547215

    There are a few different ways and techniques to have two servers exchange data. Which one is 'best' largely depends on the particular requirements.

    You may want to read some in BOL (Books On Line) - the subject "Distributed Queries" has a lot of good info and pointers on the subject.

    /Kenneth

  • March 16, 2005 at 12:14 pm

    #547339

    Thanks, I've tried reading that but I guess I'm looking for more specific examples, I don't quite understand how they get it to work, I try it and my SQL just locks up.

  • March 17, 2005 at 5:55 pm

    #547694

    I would first make certain that the collation bwteen the servers is the same and the the Distributed Transaction Coordinator is running on both servers.

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

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