Chapter 10. SQL Server System and Database Administration

by Paul Jensen

IN THIS CHAPTER

• Responsibilities of the System Administrator

• System Databases

• System Tables

• System-Stored Procedures

• Useful System Procedures

• Other Methods of Querying the System Tables

This chapter outlines the role of the SQL Server system administrator, and also examines the system databases and tables and the methods the administrator can use to query system data. An understanding of these key structures is essential in administering a SQL Server database. Just like the mechanic who fixes your car, the administrator must know where to look when problems occur.