Online Documentation for SQL Administrator for SQL Server

Using toolbar


The toolbar of the Query Editor tool provides quick access to query management tools.

 

Query Editor - Using toolbar

 

 

ConnectToServer connect to server

DisconnectFromServer disconnect from server

SelectDatabase select a database for the query

NewQuery create new query

OpenQuery load a query from an *.sql file

Apply save the query to an *.sql file

Execute execute the current query

Cancel stop the current query execution

Search find text

 

 

To execute a query you need to choose a connected database.

 

When you click the ConnectToServer Connect to server button the Server Connection dialog appears.

Note: This dialog appears every time you create a new query or open an existing one as well.

 

Query Editor - Server connection

 

 

Server Group

Select the group that the necessary server belongs to.

 

Server Name

Select the server to connect from the drop-down list of all registered servers.

 

Authentication

Specify the type of Microsoft® SQL Server™ authentication to be used for the connection: !RadioButton Windows authentication or !RadioButton SQL Server authentication.

 

!RadioButton Windows Authentication

SQL Administrator identifies user by his domain name and password which are defined automatically according to  his Windows domain user account.

 

!RadioButton SQL Server authentication

SQL Administrator identifies user by his server login and password.

If !RadioButton Server authentication is selected as the authentication type, you should provide authorization settings: Login and Password. Analyzing them a system determines information and therefore object access permissions.

 

Database

Select the database for query execution.

 

Recent

This list contains the set of databases that have been recently used for query execution.

 

All

In this area all databases located on the selected server are listed. If a connection to the selected server is not established in the SQL Administrator then click the Load button to get the list of databases on this server.

 

 


See also:

Using toolbar

Working with the SQL Editor area

Executing queries

Viewing messages