Using SQL Administrator and SQL Object Manager

SQL Administrator and SQL Object Manager are no longer provided. They have been superseded by SQL Enterprise Manager.

Servers or clients that still have old copies of SQL Administrator or SQL Object Manager can still use those tools to administer a SQL Server 6.0 server, but only after that server has run two scripts¾ADMIN60.SQL and OBJECT60.SQL¾that upgrade its stored procedures to allow SQL Administrator and SQL Object Manager to administer it. However, you will notice a few differences when using these tools to administer a SQL Server 6.0 server, as compared to administering a SQL Server 4.2 server.

When an existing SQL Server 4.2 server is upgraded to SQL Server 6.0, the old copies of SQL Administrator or SQL Object Manager are left in place, and the necessary upgrade scripts are automatically run by the setup program. You do not need to take any action to allow an upgraded server to be managed by those tools.

For new SQL Server 6.0 installations, the two upgrade scripts must be run if other servers or clients that still have SQL Administrator and SQL Object Manager installed will be used to administer the new SQL Server 6.0 server.

    To allow users of SQL Administrator and SQL Object Manager to administer a new SQL Server 6.0 server

1. From the Microsoft SQL Server 6.0 program group, start ISQL/w and connect to the new SQL Server 6.0 server.

   Or start SQL Enterprise Manager, select the new SQL Server 6.0 server from the Server Manager window, and from the Tools menu, choose Query Analyzer.

2. To allow this server to be administered by the SQL Administrator utility, from the \SQL60\INSTALL directory, open and run the script ADMIN60.SQL.
3. To allow this server to be administered by the SQL Object Manager utility, from the \SQL60\INSTALL directory, open and run the script OBJECT60.SQL.