Microsoft® SQL Server 2005 Unleashed

Chapter 6. SQL Server System and Database Administration

IN THIS CHAPTER

• What’s New in SQL Server System and Database Administration

• System Administrator Responsibilities

• System Databases

• System Tables

• System Views

• System Stored Procedures

This chapter outlines the role of a SQL Server system administrator and explores some of the methods that an administrator can use to query important system data. As with any other job, understanding the roles and responsibilities of an administrator is critical to doing the job well. You also need the right tools and the right information to do the job well and to do it efficiently.

The system data covered in this chapter provides some of the key information, and the methods discussed to access this information are ...