MSSQL: Stored procedures
Creation
Go to System Databases -> master -> Programmability -> Stored Procedures and right-click on Stored Procedures. Select New Stored Procedure option.
Salvation
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.