The stored procedure function is to simplify the database development process by grouping Transact-SQL (Microsoft’s proprietary extension to SQL) statements into manageable blocks.
To manage stored procedures in your MSSQL database, please do the following:
Scroll down to the Web hosting section.
Select the relevant domain name from the drop down box and click on the Manage button.
Click on the MSSQL Database link in the Web Tools section of your hosting control panel.
In the Manage Databases section press the Manage button to access your database administration area.
Click on the Stored Procs option in the Database menu.