123 Reg Support

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.

 

Step 3 of 7

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

 

Step 4 of 7

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

 

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.