Online Documentation for SQL Administrator for SQL Server
Using toolbar
The toolbar of the Query Editor tool provides quick access to query management tools.
connect to server
disconnect from server
select a database for the query
create new query
load a query from an *.sql file
save the query to an *.sql file
execute the current query
stop the current query execution
find text
To execute a query you need to choose a connected database.
When you click the 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.
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: Windows authentication or SQL Server authentication.
Windows Authentication
SQL Administrator identifies user by his domain name and password which are defined automatically according to his Windows domain user account.
SQL Server authentication
SQL Administrator identifies user by his server login and password.
If 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:
Working with the SQL Editor area