O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Administration Basics

You perform most database administration work through SQL Server Management Studio. Use SQL Server Management Studio to carry out many common database administration tasks, including:

  • Viewing database information

  • Checking user and system databases

  • Examining database objects

This section examines each of these tasks.

Viewing Database Information in SQL Server Management Studio

SQL Server organizes information using a top-down hierarchy that starts with server groups at the highest level and then moves down to servers, and then to databases, and then to objects. Therefore, you must work your way down to the database level to view the databases installed on a particular server instance. If you have registered a server instance ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required