I have a stored procedure, in SQL Server 2012, containing a cursor that doesn't have the second FETCH statement, so @@FETCH_STATUS is always zero and it keeps running and running and running. Is there any command that can be issued that will tell it to STOP NOW? I've tried canceling the procedure and there is a notice at the bottom of the query window that says "Cancelling query..." but nothing seems to be happening.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.