Dear Professional..

I would highly appreciate if anyone can guide me about

SET BEGIN DISTRIBUTED TRANSACTION
update first server table
update second server table
COMMIT TRANSACTION

Just want to understand, before doing the above SET command I have to create
linked Server first?

Let's assume I have a linked Server and I am trying to update table from my
first server and right after that I am trying to update table from 2nd
server, and what If 2nd server goes down, how I can handle this? like if
second server goes down will the pointer come back? or it gives time out?

Please guide me this is the right and fast solution to use distributed
transaction accross different servers / databases?

Do we have to enable RPC Remote Call in sp_configure?

Please please give me the detail and step by step solutions.

Thanks alot..