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 |
|
khufiamalik
Posting Yak Master
120 Posts |
 Posted - 2008-07-30 : 03:19:49
|
| Hello All, I have been using nested Transaction in my SP.Nested transaction is working fine and roll backs the appropriate records. When an error is raised from a child SP, I delegate it to the parent SP. But when the error is displayed , it shows my error as well as another error which I never assigned to the RaiseError Command.Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2.I would be very thankfull for your cooperation.Thanks in advance.RegardsYasir Mehmood |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-30 : 03:52:01
|
| i think you're missing out commit/rollback for the a transaction somewhere |
 |
|
|
|
|
|
Nested Transaction Error Msg Problem