Enterprise Manager

From Wikipedia, the free encyclopedia
Jump to: navigation, search
This article is about the Microsoft product. For the Oracle version, see Oracle Enterprise Manager.

Enterprise Manager is the primary administrative tool for Microsoft SQL Server 2000 and provides a MMC–based user interface that allows users to:

  • Define groups of servers running Microsoft SQL Server.
  • Register individual servers in a group.
  • Configure all Microsoft SQL Server options for each registered server.
  • Create and administer all Microsoft SQL Server databases, objects, logins, users, and permissions in each registered server.
  • Define and execute all Microsoft 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 Microsoft 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. Microsoft SQL Server Enterprise Manager is the Microsoft SQL Server 2000 MMC snap-in.

In Microsoft SQL Server 2005, Enterprise Manager is replaced by SQL Server Management Studio, which provides a single interface to functionality provided by Enterprise Manager and Query Analyzer in Microsoft SQL Server 2000.[1]

This entire statement is taken from the following Microsoft Website: http://msdn.microsoft.com/en-us/library/aa174466(v=sql.80).aspx


  1. ^ "SQL Server Enterprise Manager". Redmond, WA, USA: Microsoft. Retrieved November 10, 2011.