Export (0) Print
Expand All

SQL Server Enterprise Manager

SQL Server Enterprise Manager is the primary administrative tool for Microsoft® SQL Server™ 2000 and provides a Microsoft Management Console (MMC)–compliant user interface that allows users to:

  • Define groups of servers running SQL Server.

  • Register individual servers in a group.

  • Configure all SQL Server options for each registered server.

  • Create and administer all SQL Server databases, objects, logins, users, and permissions in each registered server.

  • Define and execute all SQL Server administrative tasks on each registered server.

  • Design and test SQL statements, batches, and scripts interactively by invoking SQL Query Analyzer.

  • Invoke the various wizards defined for SQL Server.

MMC is a tool that presents a common interface for managing different server applications in a Microsoft Windows® network. Server applications provide a component called an MMC snap-in that presents MMC users with a user interface for managing the server application. SQL Server Enterprise Manager is the Microsoft SQL Server 2000 MMC snap-in.

To launch SQL Server Enterprise Manager, select the Enterprise Manager icon in the Microsoft SQL Server program group. On computers running Windows 2000, you can also launch SQL Server Enterprise Manager from Computer Management in Control Panel. MMC snap-ins launched from Computer Management do not have the ability to open child windows enabled by default. You may have to enable this option to use all the SQL Server Enterprise Manager features.

Note  If you register additional SQL servers in Computer Management, and then either close Computer Management or connect to another computer, the servers will no longer appear in Computer Management. The registered servers will appear in SQL Server Enterprise Manager.

See Also

How to launch SQL Server Enterprise Manager in the Computer Management console (Windows)

How to enable child windows (Enterprise Manager)

Overview of the SQL Server Tools

© 2016 Microsoft