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 |
|
sanjay_jadam
Yak Posting Veteran
53 Posts |
 Posted - 2006-02-28 : 05:14:35
|
| I have a stored proc that contain insert statement.their is a trigger on that table.after executing INSERT STATEMENT in SP their is a rollback.My question is will all changes rollback that have done by trigger or the change that trigger made will not rollback its remain unchanged?? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-03-01 : 07:35:01
|
| The trigger is within the transaction, so any modifications will be rolled back. It gets tricky when you have rollbacks within the trigger itself. |
 |
|
|
|
|
|
Plz let me know