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 ...