Terminating immediately ends a debug session, and the stored procedure that you are debugging runs to completion.
To terminate a debug session:
To terminate all debug sessions, right-click in the Debug view and choose Terminate All from the pop-up menu.
If you have terminated one or more sessions and want to remove them from the Debug view, right-click in the Debug view and choose Remove All Terminated from the pop-up menu.
If you are debugging a stored procedure which contains no active breakpoints, choosing to Resume suspended threads will result in an end of the debug session (that is, the stored procedure will run to completion and the debug session will terminate).