If it accesses remote/network transactions, it requires Microsoft Distributed Transaction Coordinator (MSDTC) support to ensure that the operations are transactionally consistent. You might need to enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.
Since your operation is very simple. The workaroud is to use SqlTransaction. You commit the tranaction after mail function successes. You rollback the tranaction either database ooperation fails or mail function fails
Since your operation is very simple. The workaroud is to use SqlTransaction. You commit the tranaction after mail function successes. You rollback the tranaction either database ooperation fails or mail function fails