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.SQLIf you are using SQL Server 6.0:
\SQL60\INSTALL\OBJECT60.SQL
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.
Perform the following steps to connect to the server:
Figure G.2.
Connecting to SQL Server.
Figure G.3.
The Microsoft SQL Object Manager window.
Perform the following steps to disconnect from SQL Server:
Figure G.4.
Disconnecting from SQL Server
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.
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.
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.
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.
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.
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.
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.
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.
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.