Questionnez la Communauté
Ask any professional question and get answers from other specialists.
This might not be possible as a part of DML directly, but can we use SQL logs or some filters or anything in the tables to achieve this?
As mentioned earlier, you cannot rollback a transaction that is committed. However, you may use transaction logs to restore the database to an earlier state. In order to ... Voir Plus
No you cant
It is impossible to rollback after the transaction is commited.
No you can not rollback the tranaction once commited.
Yes you can from sysadmin cancel the workflow and then you can use rollback_transaction procedure to delrte transaction using transaction_id
once commited can't be rolled back .
You can't rollback any transaction once it is commited. but you need to do backup the database with transaction log. when ever you need to rollback, just restore the ... Voir Plus
Create a snapshot of database, then execute transaction. To undo the transaction, restore from the snapshot