Microsoft SQL database is a database management system based on Windows platform. It allows you to add, access, and process stored data. dinerdash unlock code

• Creating Microsoft SQL logins
• Creating Microsoft SQL databases
• Adding MS SQL database users
• Changing MS SQL quota

 dinerdash unlock code

Creating Microsoft SQL Loginsdinerdash unlock code

Unlike other SQL databases, you need a login to start working with MS SQL databases. So, you must stick to the following sequence:dinerdash unlock code

1. Create a login to connect to the Microsoft SQL server.
2. Create databases
3. Create users to work with Microsoft SQL databases.

To create a MS SQL login, do the following:dinerdash unlock code

1. Select MS SQL in the Databases menu.
2. Click Add New MS SQL login icon:

dinerdash unlock code

3. Enter login and password into the MS SQL Login Creation Form that shows:

dinerdash unlock code

Note: you can change password by clicking the Change icon against the login name in the Controls section.dinerdash unlock code

4. Click Submit button.
5. Agree to additional charges.

Note: To delete login, click the Trash icon against the login name, in Controls section.dinerdash unlock code

 dinerdash unlock code

Creating MS SQL Databasesdinerdash unlock code

To create a MS SQL database, do the following:dinerdash unlock code

1. Select MS SQL DBs in the Databases menu.
2. Click the Add database icon at the bottom of the page that appears:

dinerdash unlock code

3. Fill the MSSQL Database Creation form

dinerdash unlock code

4. Click the Submit button.
5. Agree to additional charges.

Note: To delete a database, click the Trash icon against the database name in Controls section.dinerdash unlock code

When MS SQL creates a database, it automatically creates a user with the same *login* as the one this database was created with.dinerdash unlock code

 dinerdash unlock code

Adding New MS SQL Database usersdinerdash unlock code

After you have created the database, it appears in the database list:dinerdash unlock code

dinerdash unlock code

Here you can learn how to add users to individual MS SQL databases. To add a new user, do the following:dinerdash unlock code

1. Select MS SQL DBs in the Databases menu.
2. On the page that appears click the name of existing database or click the Edit icon in the Controls section. The following form will show:

dinerdash unlock code

3. At the bottom of the page click Add icon against Database users field. The following form will appear:

dinerdash unlock code

4. Enter user name and click Add.
   * When you are creating a new user to the database, the system offers you to choose from the logins that aren't used by this database.
   It won't display this databse owner's login, because when MS SQL creates a database, it automatically creates a user with the same *login* as the one this database was created with. One login can be used only by one user within a database. So, login you have used to enter the database is already being used by you and can't be used to create a new user on this database.
   
5. Agree to additional charges if any.

 dinerdash unlock code

Changing MS SQL Database quotadinerdash unlock code

Total quota size is the disk space allocated for the database file and the transaction log file. Database/Transaction Log file quota ratio is the portion of disk space allocated for the database file. If you set the total quota size to 100 MB and the database/transaction log file quota ratio to 40%, then the maximum database file quota is 40 MB and the maximum log file quota is 60 MB. The more dynamic your database is, the bigger transaction log file quota ratio should be. dinerdash unlock code

To change the quota, do the following:dinerdash unlock code

1. Select MS SQL DBs in the Databases menu.
2. On the page that appears click the name of an existing database.
3. On the form that shows, click the Change quota icon against the Database quota field.
4. Enter new database log file ratio and total quota size on the next page:

dinerdash unlock code

5. Click Submit.
6. Agree to additional charges if any.