>Check out SET CURSOR_CLOSE_ON_COMMIT in the BOL.
>
>-Mike
>
>>>I needed to Begin Transaction before the 2nd cursor and then commit the transaction(s) after closing down the cursors.
>>>
>>>__Stephen
>>
>>OK that gets me through the SECOND trans of the cursor, but now 3, 4,...
>>
>>Any ideas?
Thanks I have that set to ON in 3 areas of this code? Any other ideas?
__Stephen