Summary

3 4

In this chapter, you have expanded your knowledge of SQL Server 2000 data and log files, filegroups, and automatic file growth. You now know how to create databases using the Create Database Wizard, SQL Server Enterprise Manager, and T-SQL commands. You also know two methods for viewing database and file information, as well as how to delete a database. Now you're ready to start creating tables in your database—the topic of Chapter 10.