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.SQLIf you are using SQL Server 6.0:
\SQL60\INSTALL\ADMIN60.SQL
Perform the following steps to start SQL Administrator:
Figure H.1.
The SQL Administrator icon.
Figure H.2.
Connecting to SQL Server.
Figure H.3.
The Microsoft SQL Administrator window.
Perform the following steps to disconnect from SQL Server:
Figure H.4.
Disconnecting from SQL Server.
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.
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.
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.
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.
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.
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.
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.