Top Menu

1. Click the link User for the database you want
2. Change the Permissions you would like for that User, and if you don't want to change the password, just leave both password fields blank.
3. If you would like to change the password, but not the permissions, just type in the Password (in both fields) and don't change any of the permissions.
4. Click on Submit Query .

Logging in:

1. Click in the link Admin for the database in question
2. You will be prompted to enter the database login and password
3. After logging in, you can begin working with the Admin Suite.

Description:

The Admin Suite For MS SQL Server is a web-based SQL Server Database administration tool that has been incorporated into our myCP. It is intended to handle the administration of SQL Server databases via your browser. It allows you to fully manage your databases as an alternative to MS Enterprise Manager. Best of all, we provide this free for our clients.

MS SQL Admin suite allows you to:

o create, drop, alter, copy, rename tables
o create, drop indexes
o add, drop, alter fields
o create, drop and display stored procedures
o create, drop and display triggers
o create, drop and display views
o create, drop and display rules object
o create, drop and display default objects
o add, delete, modify, duplicate records
o execute any SQL command (including stored procedures)
o build a select SQL command using a wizard
o export the result of a SQL query as a CSV file
o export the result of a SQL query as an XML file
o import a CSV file into database
o display, export and query view content
o and much more ......

Tables:

List all tables in your database and provide the links to manage those tables.

o Table Content: List records in a table. You can add/modify/duplicate/drop records or build a select to select records here. You can also export your records as a CSV or XML file or import a CSV file into your table. There are two icons ASC and DESC at the right of every field name. Click on them will sort the records by the field.

o Table Structure: Display the structure of a table. It will list all columns, indexes and triggers for you to manage.

Indexes in databases are similar to indexes in books. In a book, an index allows you to find information quickly without reading the entire book. In a database, an index allows the database program to find data in a table without scanning the entire table. An index in a book is a list of words with the page numbers that contain each word. An index in a database is a list of values in a table with the storage locations of rows in the table that contain each value. Indexes can be created on either a single column or a combination of columns in a table and are implemented in the form of B-trees. An index contains an entry with one or more columns (the search key) from each row in a table. A B-tree is sorted on the search key, and can be searched efficiently on any leading subset of the search key. For example, an index on columns A, B, C can be searched efficiently on A, on A, B, and A, B, C.

Triggers are executed when a specified data modification, such as an attempt to delete a row, is attempted on the table on which the trigger is defined. With the Trigger object, you can:
+ Create a SQL Server trigger on an existing SQL Server table.
+ Remove an existing SQL Server trigger from a SQL Server table.
+ Generate a Transact-SQL script to use in other tools to recreate an existing SQL Server trigger.
+ Change ownership of an existing SQL Server trigger.

The Name property of a Trigger object is a character string. The value of the property identifies a SQL Server trigger by name and must conform to the rules for trigger naming. The Name property is required when creating a SQL Server trigger.

o Select Content: Using the convenient set of tools provided, you can build a sophisticated instruction to select the records from the current table. For example, if you wish to achieve results produced by:
select [id],[name] from table where [id]=1 AND [id]=2
1. select "=" from the first dropdown menu.
2. input 1 in the first text field.
3. select AND from the second dropdown menu.
4. input 2 in the second text field.
5. Check the Checkbox for the columns you want to display. In this example, you should check the checkbox of columns "id" and "name".
6. Check on button Select to run the select.

o Copy Table: Here, you can copy the content or the structure of current table to another table.

o Rename Table: Rename your current table to another name.

o Empty Table: Empty all contents in current table. There will be an alert window for you to confirm the operation.

o Drop Table: Click on it will drop the table. There is an alert box window to confirm it.

Views:

It will list all views you have and you can create new views here. You need to input the SQL syntax into textarea to create a view.

A view is a virtual table whose contents are defined by a query. Like a real table, a view consists of a set of named columns and rows of data. However, a view does not exist as a stored set of data values in a database. The rows and columns of data come from tables referenced in the query defining the view and are produced dynamically when the view is referenced.

Stored Procedure:

Here, you will find all your stored procedures and give you the ability to manage them.

Stored procedures in SQL Server are similar to procedures in other programming languages in that they can:
o Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch.
o Contain programming statements that perform operations in the database, including calling other procedures.
o Return a status value to a calling procedure or batch to indicate success or failure (and the reason for failure).

Rules:

You can manage rules of current database.

A SQL Server rule is a Transact-SQL condition_expression syntax element that defines a data-integrity constraint. A rule can be bound to a column or user-defined data type. condition_expression is executed to validate data for a single column when a value is inserted into the column bound by the rule.
With the Rule object, you can:
o Create a SQL Server rule that defines an integrity constraint.
o Bind an existing SQL Server rule to a column or user-defined data type.
o Remove the constraint from a column or user-defined data type by unbinding a SQL Server rule.
o Remove a SQL Server rule definition from a SQL Server database.
o Generate a Transact-SQL script to create the rule represented by the object.

Defaults:

You can manage default settings of the current database.

Creates an object called a default. When bound to a column or a user-defined data type, a default specifies a value to be inserted into the column to which the object is bound (or into all columns, in the case of a user-defined data type) when no value is explicitly supplied during an insert. Defaults, a backward compatibility feature, perform some of the same functions as default definitions created using the DEFAULT keyword of ALTER or CREATE TABLE statements. Default definitions are the preferred, standard way to restrict column data because the definition is stored with the table and automatically dropped when the table is dropped. A default is beneficial, however, when the default is used multiple times for multiple columns.

SQL Query:

You can type any SQL query in the text area in SQL Query table. The SQL query will run immediately.