Yes, I have read both of those articles and many more associated Linked Servers and Distributed transactions, including the interaction with Firewalls. That is how I got as far...

It kinda sounds like I do not need to embed TRANSACTIONs inside my stored procedures.

Here is what I am trying to accomplish:

1) In the (WinForms) application, start a transaction.

2) Execute...

I am guessing this would return:

0

1

2

1

But, maybe the ROLLBACK here would actually force all linked transactions to be rolled back and the last @@TRANCOUNT would return 0? Is this...