How do I query my MSSQL database?

This article applies to 123-reg Shared Hosting and 123-reg Premium Hosting packages.

If you need to retrieve specific data from your database, you can create a query to recover the desired data. For example, if you were running a forum, you could create a query to view all of the users that have posted a certain amount of times, or find a list of users that have posted within the last week. 

To query your MSSQL database, please do the following:

1

Login to your 123-reg control panel.

2

Scroll down to the Web hosting section.

3

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

 Web_hosting_section.jpg
4

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

5

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

6

Click on the Query button, this is located in the menu on the left hand side of the screen.

7

Enter your query into the box provided and click on the Execute query button.