Home Forums SQL Server 2012 SQL 2012 - General enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE RE: enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE

  • does the storedprocedure ServerB.MyDatabase.MyStoreProcedure itself use an additional call to a linked server, by chance? so it double hops?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!