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,...

Wow, thanks! That fixed that problem fast. Thanks for the help!

-Jeremy