1. Home
  2. SQL
  3. Microsoft SQL Server 2000

Summary

Administering a SQL Server is a time-consuming, complex task. Understanding the structure of the system and the proper tools and methods to extract and modify system information will help you manage your databases efficiently. The next chapter, "Creating and Managing Databases," takes an in depth look at this aspect of SQL Server administration.



    		Part I: Welcome to Microsoft SQL Server
    		Part II: SQL Server Tools and Utilities
    		Part III: SQL Server Administration
    		Chapter 8. Installing and Upgrading SQL Server
    		Chapter 9. Client Installation and Configuration
    		Chapter 10. SQL Server System and Database Administration
    		Responsibilities of the System Administrator
    		System Databases
    		System Tables
    		System-Stored Procedures
    		Useful System Procedures
    		Other Methods of Querying the System Tables
    		Summary
    		Chapter 11. Creating and Managing Databases
    		Chapter 12. Creating and Managing Tables in SQL Server
    		Chapter 13. Creating and Managing Indexes
    		Chapter 14. Implementing Data Integrity
    		Chapter 15. Security and User Administration
    		Chapter 16. Database Backup and Restore
    		Chapter 17. Database Maintenance
    		Chapter 18. SQL Server Scheduling and Notification
    		Chapter 19. Managing Linked and Remote Servers
    		Chapter 20. Importing and Exporting SQL Server Data Using BCP and DTS
    		Chapter 21. Administering Very Large SQL Server Databases
    		Chapter 22. Data Replication
    		Chapter 23. SQL Mail
    		Chapter 24. SQL Server Clustering
    		Chapter 25. Defining System Administration and Naming Standards
    		Part IV: Transact-SQL
    		Part V: SQL Server Internals and Performance Tuning
    		Part VI: Additional SQL Server Features