Customizing the SQL Server 7.0 MMC

SQL Server Enterprise Manager uses the Microsoft Management Console (MMC). Thus, you can snap in utilities to the MMC so that you can manage a variety of services within the console. For example, you can add the Internet Information Server, Transaction Server, and Index Server snap-ins to the MMC for SQL Server. 

By default, however, you open the SQL Server Enterprise Manager in user mode rather than author mode--which means you can't snap in utilities in the MMC. To switch SQL Server Enterprise Manager to author mode, in SQL Server Enterprise Manager, choose Console | Options to display the Options dialog box. Check Always Open Console Files In Author Mode, then click OK. Close SQL Server Enterprise Manager and then reopen it (so that it's now in author mode). 

To add a snap-in to the MMC, choose Console | Add/Remove Snap-In. In the Add/Remove Snap-In dialog box, click Add. You should now see a list of available tools for snap in (this list will vary based on the utilities you have installed on your server). Select the snap-in you want to include in your MMC, then click Add. (You'll have to select each snap-in individually and click Add--you can't select a list of snap-ins to add to the MMC.) When you're done, click Close and then OK. You should now see all of your snap-ins displayed in the console tree in SQL Server Enterprise Manager.  Once you've customized the SQL Server Enterprise Manager MMC, you should choose Console | Save to save the console-otherwise you'll have to re-add the snap-in utilities the next time you start SQL Server Enterprise Manager.

SQL Index

Main Index