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