Appendix G
Object Manager



The Object Manager is a graphical object administration tool provided with SQL Server 4.x. This tool allows you to manage tables, indexes, stored procedures, and other SQL Server objects.


NOTE: This appendix is intended to be a reference for users running a version of SQL Server before version 6.x. The Object Manager 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. However, sites that run SQL Server 4.x and SQL Server 6.x can use the Object Manager to administer a SQL Server 6.x database. To administer SQL Server 6.x with the Object Manager, you must run one of the following scripts.

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

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


Starting Object Manager

To start Object Manager, double-click the SQL Object Manager icon in the SQL Server for Windows NT (Common) group (see Figure G.1).

Figure G.1.
The SQL Object Manager icon.

Connecting to the Server

Perform the following steps to connect to the server:

  1. Double-click the SQL Object Manager icon in the SQL Server for Windows NT (Common) group. The Microsoft SQL Object Manager and the Connect Server dialog box appear (see Figure G.2).

    Figure G.2.
    Connecting to SQL Server.

  2. To connect to SQL Server, you must enter the server name, login ID, and password.

  3. Click the Connect button to connect to the server. The Microsoft SQL Object Manager window appears (see Figure G.3).

Figure G.3.
The Microsoft SQL Object Manager window.

Disconnecting from SQL Server

Perform the following steps to disconnect from SQL Server:

  1. From the Microsoft SQL Object Manager 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 (see Figure G.4).

  3. Click the Disconnect button.

Figure G.4.
Disconnecting from SQL Server

Browsing Database Objects

From the Microsoft SQL Object Manager window, click the Objects toolbar button. The Database Objects dialog box appears. From here, you can browse all objects contained in a database. From this dialog box, you can directly edit an object by double-clicking the object (see Figure G.5).

Figure G.5.
Browsing database objects.

Managing Tables

Starting with the Microsoft SQL Object Manager window, choose Tables from the Manage menu. The Manage Tables dialog box appears (see Figure G.6). From this dialog box, you can create, alter, rename, and drop a table.

Figure G.6.
Managing tables.

Managing Indexes

Starting with the Microsoft SQL Object Manager window, choose Indexes from the Manage menu. The Manage Indexes dialog box appears (see Figure G.7). From this dialog box, you can create, modify, rename, and drop an index.

Figure G.7.
Managing indexes.

Managing Stored Procedures

Starting with the Microsoft SQL Object Manager window, choose Stored Procedures from the Manage menu. The Manage Stored Procedures dialog box appears (see Figure G.8). From this dialog box, you can create and edit stored procedures.

Figure G.8.
Managing stored procedures.

Managing Object Permissions

Starting with the Microsoft SQL Object Manager window, choose Object Permissions from the Object menu. The Object Permissions dialog box appears (see Fig- ure G.9). From this dialog box, you can grant and revoke object permissions.

Figure G.9.
Managing object permissions.

Transferring Data

Starting with the Microsoft SQL Object Manager window, click the Transfer toolbar button. The Transfer Data dialog box appears (see Figure G.10). From this dialog box, you can graphically import and export data.

Figure G.10.
Transferring data.

Generating SQL Scripts

Starting with the Microsoft SQL Object Manager window, click the Scripts toolbar button. The Generate SQL Scripts dialog box appears (see Figure G.11). From this dialog box, you can export SQL object definitions.

Figure G.11.
The Generate SQL Scripts dialog box.

Running Queries

From the Microsoft SQL Object Manager window, click the Query toolbar button. The Query window appears (see Figure G.12). From this window, you can build and execute SQL queries.

Figure G.12.
The 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.