How do I manage stored procedures in my MSSQL database?

This article will show you how to manage stored procedures in your MSSQL database

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:

Please note: MSSQL databases are no longer available on any Web Hosting plans bought after July 2020 or Premium Hosting plans bought after August 2020.

Step 1 of 7

Start by logging in to your 123 Reg Control Panel.

 

Step 2 of 7

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

Manage Shared Web Hosting

 

Step 3 of 7

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

Manage Legacy hosting

 

Step 4 of 7

On the next page, select Manage for the domain you wish to update.

Manage hosting domain

 

Step 5 of 7

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

Step 6 of 7

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

Step 7 of 7

Click on the Stored Procs option in the Database menu.

Related Support Material:

  1. How do I find my database hostname?
  2. How do I import a MySQL database with SSH?
  3. How do I resolve ‘Error establishing a database connection’?
  4. How do I update the database password within my configuration file?
  5. How do I access and manage my products?
  6. How do I add and manage a calendar on my website?