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 |
|
deepakugale
Starting Member
33 Posts |
 Posted - 2010-03-10 : 00:28:33
|
| Hi All, My stored procedure is having some error on production server,As SP contains transaction with try-catch block, all operations get rollbacked,as nested SP's are called within same SP,i am not able to rectify which sp had problem.What step should i take to solve this problem ? As problem is on production server,its very sensitive . |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-03-10 : 04:47:49
|
| GenerallyCopy the DB to whatever test environment you have running.Debug the sp there. run it manually in a management studio window with the parameters sniffed from you application.if nescessary take out the try catch blocks (in test environment) and do an explict begin transaction rollback transaction block around the sp. You should see a helpful message in red text where you get the error.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
|
|
|
Error on production server