Viewing Database Details

The details of a database, such as the size, collation, filegroups, database options, and so on, can be viewed via SQL Server Management Studio or using the sp_helpdb stored procedure. The process used to do this is explained in the sections below.

Viewing Database Details with SQL Server Management Studio

The following steps explain the process of viewing the details of a database via SQL Server Management Studio:

  1. Click the Start button, point to All Programs, select Microsoft SQL Server 2005, and then select SQL Server Management Studio.

  2. Log in to the instance you want to use, and then click on the + sign next to Databases to expand the list of databases.

  3. Select a database, right-click it, and then select Properties from ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.