Alison Balter's Mastering Access 2002 Enterprise Development

Overview of the SQL Server Components

SQL Server 2000 is composed of several important components. Each plays its own important role in the database management process. The components include:

• Enterprise Manager— The Enterprise Manager, pictured in Figure 4.1, is a graphical tool that you can use to manage almost every aspect of SQL Server. As you can see in Figure 4.1, the Enterprise Manager provides you with a hierarchical view of your database server. Using the Enterprise Manager, you can create and drop databases, tables, views, stored procedures, and database diagrams. You can also schedule jobs, back up your databases, and perform other management tasks. The section of this chapter titled “Introduction to the Enterprise Manager” and other ...