Cannot save a document while it is being used by TSQL debugger.

You are debugging a stored procedure that is still open in the SQL editor. You cannot save a stored procedure document while it is being used by the SQL debugger. To save the stored procedure, you must first stop the debug process.

To correct this error

  1. On the Debug menu, choose Stop Debugging.

  2. Save the stored procedure.