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.