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 |
|
sql_2k
Starting Member
26 Posts |
 Posted - 2008-05-12 : 07:40:23
|
| Hi Need a help for the below req.I have a SP which calls another SP with in a Cursor. The main SP updated two of the DB tables. Based on the data passed from main SP the nested SP updates another two table. What I want at the end of loop the transaction will be committed. In between if any point it fails means the whole transaction will be rollback.I am using TRY & CATCH to handle transaction commit & Rollback . But I am getting below error Error coming in SQL end is:Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.Please advise. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-12 : 07:54:48
|
Post the code you use.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Error on Commit/Rollback