How do I manage stored procedures in my MSSQL database?

This article applies to 123 Reg Shared Hosting and 123 Reg Premium Hosting packages.

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:

  • Step 1 of 6

    Login to your 123 Reg control panel.

  • Step 2 of 6

    Scroll down to the Web hosting section.

  • Step 3 of 6

    Select the relevant domain name from the drop down box and click on the Manage button.

    Web_hosting_section.jpg
  • Step 4 of 6

    Click on the MSSQL Database link in the Web Tools section of your hosting control panel.

  • Step 5 of 6

    In the Manage Databases section press the Manage button to access your database administration area.

  • Step 6 of 6

    Click on the Stored Procs option in the Database menu.