sgmunson
SSC Guru
Points: 110651
More actions
August 15, 2018 at 6:25 am
#2001833
My gut says it's something in the SQL syntax... I'd also check the values for the Options on the Linked Server, and be sure to set RPC and RPC Out to True.
EDIT: Also set Enable Promotion of Distributed Transactions for RPC to True.
Steve (aka sgmunson) 🙂 🙂 🙂Rent Servers for Income (picks and shovels strategy)
dcotterman
SSC Veteran
Points: 270
August 17, 2018 at 7:58 am
#2002242
That seems to have corrected the problem. Big thank you Steve!!
August 20, 2018 at 7:42 am
#2002481
dcotterman - Friday, August 17, 2018 7:58 AMThat seems to have corrected the problem. Big thank you Steve!!
You're very welcome.
Viewing 3 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply