Using MS SQL

What is MS SQL

Microsoft SQL (MS SQL) Server is a relational database management system produced by Microsoft. It supports Transact-SQL (T-SQL), which is a superset of SQL (Structured Query Language), the most common database language. T-SQL adds additional syntax for use in stored procedures and affects the syntax of transactions support.

MS SQL is used for small-to-medium sized databases as well as large enterprise databases.

Create a new MS SQL database

To create a new MS SQL database:

1. Log into your control panel.
2. Go to Scripting and Add-Ons > MS SQL to get to the Manage MS SQL tool
3. In the Add New Database section, enter the database name. Note: If the Add New Database section is not on the page, then all of the databases included in your plan have been created. Contact us for information on adding another database.
   
4. Each MS SQL database must have a unique name across all our servers.
   We recommend that you use your hosting account username as a prefix on your database name to help identify ownership and ensure uniqueness.
   Example: username_catalog
   In the above example, the hosting account username is hostinguser, and the database name is demodb, resulting in the hostinguser_demodb database name.
    
5. Enter the user login name, and then enter and confirm the password for the login.
   Important: This original login becomes the database owner. It will have full administrative access to the database and cannot be deleted after the database is created.
   
   
   Sometimes a chosen login is not accepted, typically because it's already being used by a different user. However, once you create a login successfully, you can use that login for more than one database in your account.
    
6. Click Submit to create the database.
   The page redisplays with the new database listed in the Current MS SQL Databases section

Manage your MS SQL databases

You can use the Manage MS SQL tool to create and manage your databases.

1. Log into your control panel
2. Go to Scripting and Site Add-Ons > MS SQL Database to get to the Manage MS SQL tool
   
   You can perform functions through this tool and access myLittleAdmin to administer your database.
   1. To access myLittleAdmin, click on a Login name for a database
      

Delete an MS SQL database

To delete, or drop a database:

1. Log into your control panel.
2. Go to Scripting and Site Add-Ons > MS SQL Database to get to the Manage MS SQL tool
   All the databases in your account are displayed in a table.
   
3. Click Drop next to the database you wish to delete

Find more help for MS SQL

Visit the Microsoft SQL Server Support area where you can access the Knowledge Base, FAQs, and other helpful information and links.

Number of MS SQL databases you can create

The plans with MS SQL include two databases.

• If MS SQL is not listed in the Scripting and Site Add-Ons section of your control panel, click Upgrade Hosting at the top of the page to learn about plans that include MS SQL.
  You can also review our plan comparison page.
• If you need more than two databases, contact us for more information