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.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net