Appendix H
SQL Administrator



The SQL Administrator is a graphical object administration tool provided with SQL Server 4.x. This tool allows you to manage devices, databases, logins, remote servers, and server configuration.


NOTE: This appendix is intended as a reference for users running a version of SQL Server before version 6.x. The SQL Administrator is not included with SQL Server 6.x. Use the Enterprise Manager included with SQL Server 6.x to perform the functions discussed in this appendix. Those sites that run SQL Server 4.x and SQL Server 6.x can use the SQL Administrator to administer a SQL Server 6.x database. To administer SQL Server 6.x from the SQL Administrator, you must run one of the following scripts.

If you are using SQL Server 6.5:
\MSSQL\INSTALL\ADMIN60.SQL

If you are using SQL Server 6.0:
\SQL60\INSTALL\ADMIN60.SQL


StartingSQL Administrator

Perform the following steps to start SQL Administrator:

  1. Double-click the SQL Administrator icon in the SQL Server for Windows NT (Common) group (see Figure H.1). The Connect Server dialog box appears. In the Connect Server dialog box, you must enter the server name, login ID, and password.

    Figure H.1.
    The SQL Administrator icon.

  2. Click the Connect button to connect to the server (see Figure H.2). The Microsoft SQL Administrator dialog box appears (see Figure H.3).

Figure H.2.
Connecting to SQL Server.


Figure H.3.
The Microsoft SQL Administrator window.

Disconnecting from SQL Server

Perform the following steps to disconnect from SQL Server:

  1. From the Microsoft SQL Administrator window, click the Connect toolbar button. The Connect Server dialog box appears.

  2. From the Server drop-down list box, select the name of the server from which you want to disconnect.

  3. Click the Disconnect button (see Figure H.4).

Figure H.4.
Disconnecting from SQL Server.

Managing Devices

From the Microsoft SQL Administrator window, click the Devices toolbar button. The Device Management dialog box appears (see Figure H.5). Using the Manage menu option, you can create, drop, and edit devices. Double-clicking an existing device displays the properties of the selected device.

Figure H.5.
Managing devices.

Managing Databases

From the Microsoft SQL Administrator window, click the DB toolbar button. The Database Management dialog box appears (see Figure H.6). Using the Manage menu option, you can create, alter, drop, and edit a database.

Figure H.6.
Managing databases.

Managing Logins

From the Microsoft SQL Administrator window, click the Logins toolbar button. The System Logins Management dialog box appears (see Figure H.7). Using the Manage menu option, you can create, edit, and drop a system login.

Figure H.7.
Managing logins.

Managing Remote Servers

From the Microsoft SQL Administrator window, click the Remotes toolbar button. The Remote Server Management dialog box appears (see Figure H.8). Using the Manage menu option, you can create, edit, and drop remote server information.

Figure H.8.
Managing remote servers.

Managing SQL Server

From the Microsoft SQL Administrator window, click the System toolbar button. The Sys Options/Active Resources dialog box appears (see Figure H.9). From this dialog box, you can view system processes. The information in this dialog box can also be obtained by using the sp_who system procedure. Using the Manage menu option, you can configure SQL Server and issue DBCC commands.

Figure H.9.
Managing SQL Server.

Running Queries

From the Microsoft SQL Administrator window, click the Query toolbar button. The Query window appears (see Figure H.10). From this window, you can create and execute SQL queries.

Figure H.10.
Query window.


DISCLAIMER


To order books from QUE, call us at 800-716-0044 or 317-361-5400.

For comments or technical support for our books and software, select
Talk to Us.

© 1997, QUE Corporation, an imprint of
Macmillan Publishing USA, a Simon and Schuster Company.