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. Go to the Hosting Tools in the upper-right corner. 
   
2. Under the Advanced Tools option, look for MS SQL Database.
   
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. Go to the Hosting Tools in the upper-right corner. 
   
2. Under the Advanced Tools option, look for MS SQL Database.
   
3. To access myLittleAdmin, click on a Login name for a database under Current MS SQL Databases.
   
4. You can perform functions through this tool and access myLittleAdmin to administer your database.

Delete an MS SQL database

To delete, or drop a database:

1. Go to the Hosting Tools in the upper-right corner. 
   
2. Under the Advanced Tools option, look for MS SQL Database.
   
3. Once in the Manage MS SQL tool, all the databases in your account are displayed in a table.
   
4. 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.