Introduction.
PART I: Getting Started.
Chapter 1: The Microsoft SQL Server 2000 System Administration Exam.
Chapter 2: Exam Prep Roadmap: A SQL Server 2000 Primer.
PART II: Installing and Configuring SQL Server 2000.
Chapter 3: Planning to Implement SQL Server 2000.
Chapter 4: Installing SQL Server 2000.
Chapter 5: Upgrading to SQL Server 2000.
Chapter 6: Troubleshooting Installation Problems.
Chapter 7: Configuring SQL Server to Send E-Mail.
PART III: Creating SQL Server Databases.
Chapter 8: Designing Databases.
Chapter 9: Creating Databases.
Chapter 10: Managing Databases.
Chapter 11: Creating and Managing Database Objects.
PART IV: Managing, Monitoring, and Troubleshooting Databases.
Chapter 12: Managing and Optimizing Database Performance.
Chapter 13: Optimizing Data Storage.
Chapter 14: Backing Up Databases.
Chapter 15: Restoring Databases.
Chapter 16: Using Database Monitoring and Troubleshooting Tools.
PART V: Transferring Data.
Chapter 17: Integrating SQL Server with Internet Information Services.
Chapter 18: Importing and Exporting Data.
Chapter 19: Installing, Configuring, and Troubleshooting Replication.
PART VI: Securing SQL Server.
Chapter 20: Configuring Login Security.
Chapter 21: Implementing Permissions.
Chapter 22: Auditing SQL Server.
PART VII: Managing, Monitoring, and Troubleshooting SQL Server 2000.
Chapter 23: Automating Administrative Tasks and Alerts.
Chapter 24: Optimizing Hardware Resources.
Chapter 25: Monitoring and Troubleshooting SQL Server.
PART VIII: The Part of Tens.
Chapter 26: Ten Terrific Exam Day Tips.
Chapter 27: Ten MCSE Certification Resources.
PART IX: Appendix.
Appendix: About the CD.
Index.
Hungry Minds, Inc. End-User License Agreement.
Installation Instructions.
Book Registration Information.