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-10-17 : 00:51:49
|
| Hello all,I have a Chain of different SPs which are called fromn one another I have been using Transaction in these SPs.When ever any error in any inner SP occurs all the data is rolled backedBUT the problem is that Cursors are not rolled backed autmatically.Is there any query or methodology by which I can Drop and Deallocate all the Cursors opened by any inner SP????? |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-17 : 07:41:23
|
| Set inner SPs to return value on success then check this value in outer SPs. Use this to determine if Cursors needs reset. |
 |
|
|
|
|
|
How to Drop the Cursors created by inner SP