Go to System Databases -> master -> Programmability -> Stored Procedures and right-click on Stored Procedures. Select New Stored Procedure option.


Once the stored procedure has been created, click on Parse. If parsing is successful, click on Execute. If execution is successful, right-click on Stored Procedures and select Refresh. The stored procedure should be visible now.