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.
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.