Post reply

Insert on Linked Server

  • March 14, 2005 at 1:29 am

    #66586

    I have a linked server (SQL 2000 on box boxes)

     

    and I can insert onto the linked server from the query window with no problems, but if I put that insert into a stored procedure it hangs my server, so I thought I'd try a trigger, which I can get to work right either.

     

    Does anyone have a guide as to which method is better, and perhaps a WORKING example of how you can get a stored procedure to work on a linked server? 

  • March 14, 2005 at 1:09 pm

    #546912

    I guess nobody knows how to do this.  I'll keep researching.

  • March 14, 2005 at 1:37 pm

    #546923

    Read the BOL section titled "BEGIN DISTRIBUTED TRANSACTION"

    And also the section titled "SET REMOTE_PROC_TRANSACTIONS"

  • March 14, 2005 at 2:10 pm

    #546932

    Thank you PW, but what is BOL?

  • March 14, 2005 at 2:19 pm

    #546937

    Start Menu->Programs->Microsoft SQL Server->Books Online

  • March 14, 2005 at 2:47 pm

    #546942

    ah, Books Online I've heard of. I'd never seen it at BOL before. Thank you kind sir or mam.. It's hard to tell

Viewing 6 posts - 1 through 5 (of 5 total)

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