myLittleAdmin is a web-based MSSQL Server administration tool. It brings a rich graphical interface for database management through a browser. It can perform the same operations as the SQL Server Management Studio from Microsoft. Practically, it has the same structure of database viewing and way of working with it. When using myLittleAdmin, you can add/remove/modify tables, rows, security settings of the database, execute sql queries using interface similar to SQL Server Management Studio, but without necessity to download and install any large application on the local computer.
To start using this tool first login to the myLittleAdmin interface by visiting the following link:
https://mla.ixwebhosting.com URL. You will need the following information to login:
If you do not have these details, please login to your H-Sphere control panel and click on the MSSQL Server icon to verify the database username and its password. You can obtain this information by accessing your H-Sphere control panel. For more information please follow the following links:
how to create a MSSQL database: Creating an MSSQL Database
how to create a MSSQL database user: Creating an MSSQL Database User
Here is a little interface guide for myLittleAdmin:
1. Main interface.
Navigation bar. The navigation bar offers several sections:
Security: This is where server security objects (like logins, roles or credentials) are located.
Server Objects: This is the place where server objects are located.
Management: This section allows to check the server activity and to display the error log.
Help: Offers direct link to myLittleAdmin Community Forums.
2. Content zone.
The content zone is always built with 4 zones:
Creating a table:
Display the table list of your database
Start to choose the schema this new table will belong to. Default value is dbo.
Then give this new table a name.
At last, define the columns of this new table. When checked, the key checkbox specifies that this column will be part of the primary key. For each column, you must specify a name and a type.
Once this has been done, click the Create button.
Tip: By clicking on the icon, you will display the Transact SQL script to create the table.
Adding a relationship to a table:
Displaying and editing table content:
Tip: You can edit column value directly inside the grid. Just click on the value you want to edit. A textbox will appear; make the change and hit the Enter key. Hitting the Escape key will cancel the change.
You can download a full guide of how to manage MSSQL databases via myLittleAdmin here: (mla_guide_edited)