O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required