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.