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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Server: Msg 266 and Server: Msg 3903

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 262
Transaction 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 1024
Transaction 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 371
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

NOTE:wbospsiIncident, wbospsiContactInternal are encrypted
Please 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 SP

error 3: reverse of 1 & 2, you have the rollback but no begin transaction

if you do not have a file stored somewhere to modify the SPs, recreate them or try to decrypt them

--------------------
keeping it simple...
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -