Skip to main content
Go to the Studio
SQL Server

SQL Server - Rollback a transaction

SQL Server - Rollback a transaction

Undoes every operation performed inside a SQL Server transaction begun with SQL Server: Begin transaction. Useful for error handling — when a failure happens, rolling the transaction back guarantees that no partial change is written to the database.


Options​

Connection​

Reference to the SQL Server: Connection action whose transaction will be rolled back.

Returns​

This action has no returns.

Rules and Conditions​

  • The Connection field is required.
  • This action must be used after SQL Server: Begin transaction.
  • After the rollback, every operation performed inside the transaction is undone.
  • This action is usually used in the flow's error handling blocks.