Thanks for that. I don't totally understand the use of XACT_ABORT ON but when I used it and took off the distributed transaction, the code worked... all the way...
Welp, now that I have the linked server queries working, I'm having trouble with putting them into a stored procedure. I know each of the queries runs by itself,...