Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prasath_s01
Starting Member
1 Post |
 Posted - 2008-08-06 : 12:45:01
|
| hiI have executed the stored procedure which inserted some fields in the table . NOw i want to roll back the changes. I have executed with wrong parameters Can any one help me |
|
|
sross81
Posting Yak Master
228 Posts |
Posted - 2008-08-06 : 12:49:01
|
Did you do run BEGIN TRANSACTION before you ran the statments that did the insert? If so you should be able to type ROLLBACK TRANSACTION because it has not committed to the database yet. If you didn't do that I thought there wasn't a way to rollback.quote:
Originally posted by prasath_s01
hiI have executed the stored procedure which inserted some fields in the table . NOw i want to roll back the changes. I have executed with wrong parameters Can any one help me
Thanks in Advance!Sherri |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-06 : 12:50:47
|
| If you're not explicitly using a transaction,then only way is restore from last transaction log backup |
|
|
|
|
|
|
How to roll back the stored procedure