Hey there,
If you want to do it in the application level, use
TransactionScope
[
^]. Otherwise, you can create a stored procedure to perform these tasks which will return a value based on the success of the requested tasks. You can use
BEGIN TRANSACTION
[
^] within the SP for managing transactions.
For an example in SQL transactions
click here[
^]
Hope this helps, regards