• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

Rolling back UPDATE

If I executed a sp that updates a table, is there a way to roll back what was updated?
0
htabbach
Asked:
htabbach
1 Solution
 
Patrick MatthewsCommented:
If you wrapped the action in a transaction, and if you haven't committed that transaction, just issue a ROLLBACK.

If not, I hope you have a backup pre-UPDATE...
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now