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.
This entire statement is taken from the following Microsoft Website: http://msdn.microsoft.com/en-us/library/aa174466(v=sql.80).aspx
Famous quotes containing the words enterprise and/or manager:
“In enterprise of martial kind,
When there was any fighting,
He led his regiment from behind—
He found it less exciting.”
—Sir William Schwenck Gilbert (1836–1911)
“I knew a gentleman who was so good a manager of his time that he would not even lose that small portion of it which the calls of nature obliged him to pass in the necessary-house, but gradually went through all the Latin poets in those moments. He bought, for example, a common edition of Horace, of which he tore off gradually a couple of pages, read them first, and then sent them down as a sacrifice to Cloacina: this was so much time fairly gained.”
—Philip Dormer Stanhope, 4th Earl Chesterfield (1694–1773)