Best practive to recover an CRUD statement to a linked server if connection is lost

I am looking for the best practice for the following scenario.

We have a CRM in our company. When an employee updates the record of a company, there is trigger that fires a stored procedure which has a CRUD statement to the linked server hosting the SQL DB of our website.

---

Question:

What happens when the connection is lost in the middle of the CRUD and the SQL DB of the website did not get updated? What would be the best way to have the SQL statement processed again when the connection is back?

---

The configuration:

Local: SQL server 2008 R2

Website: SQL server 2008

---

Thank you for your help.