2 Select the database to view and expand all options.
3 In all expanded lists, select the Programmability folder and expand it.
4 In the Programmability folder, select Stored Procedure and click the+sign in front of it to expand it. The drop-down list will display all stored procedures of the system and users.
5 select the stored procedure to view, and then select: Script the stored procedure-> Change to-> New Query Editor Window. You can modify the stored procedure.
The code of the stored procedure will be displayed on the right. After saving, you can modify the code and execute it successfully.