Welcome to Lesson 1 of the SQL Server 2000 Tutorial. In this lesson we will cover the Enterprise Manager. I hope you enjoy the lesson.

Enterprise Manager

Enterprise Manager

Enterprise Manager is the graphical user interface used primarily for database administration.  To open Enterprise Manager go to Start, All Programs, Microsoft SQL Server, Enterprise Manager.

 

Enterprise Manager is divided into two panes.  The left panes is the console tree.  The right pane is the details pane.

On the console pane, click on the + next o Microsoft SQL Server to expand the tree.  Expand the console until you get to the (local) Database server.

 

Expand Databases tree by clicking on the +.  This shows all the databases currently installed on this instance of SQL Server.  By Default, SQL Server installs six databases: master, model, msdb, Northwind, pubs, and tempdb.

The master, model, msdb, and tempdb are systems databases that should not be tempered with.  They are used by SQL Server to store information pertinent to its own operation.  The Northwind and Pubs databases are sample databases that we will use throughout this tutorial.

As you can see there are plenty of uses for Enterprise Manager.  For example you can manage SQL Server logins under the security section.  We will focus on each section in later lessions.  For now expand all the + and look at all the possibilities with the Enterprise Manager.