Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: View or Change the Properties of a Database (SQL Server Management Studio)

This topic describes how to view a database by using Object Explorer in SQL Server Management Studio.

To view a database

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand Databases, right-click the database to view, and then click Properties.

  3. In the Database Properties dialog box, select a page to view the corresponding information. For example, select the Files page to view data and log file information.

    For a description of each option, see Setting Database Options.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.