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 |
sippon77
Starting Member
13 Posts |
Posted - 2005-05-09 : 02:04:36
|
help!!!,i am getting the following error when itry to execute one sproc from another.Server: Msg 266, Level 16, State 2, Procedure wbospsiContactInternal, Line 262Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.Server: Msg 266, Level 16, State 2, Procedure wbocpscIncident, Line 1024Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.Server: Msg 3903, Level 16, State 1, Procedure wbospsiIncident, Line 371The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.NOTE:wbospsiIncident, wbospsiContactInternal are encryptedPlease let me know what is the cause of this error and how to correct/handle this error.-sippon77 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-09 : 04:03:20
|
errors 1 & 2: you have a begin transaction without the commit or rollback transaction or the commit or rollback could not be reached in your SPerror 3: reverse of 1 & 2, you have the rollback but no begin transactionif you do not have a file stored somewhere to modify the SPs, recreate them or try to decrypt them--------------------keeping it simple... |
|
|
pedrodourado
Starting Member
1 Post |
Posted - 2011-10-04 : 13:54:36
|
This topic help me to solve a similar problem (questions 1 and 2)Thanks a lot |
|
|
|
|
|
|
|