Page 45 - DCAP508_DATABASE_ADMINISTRATION

Unit 3: SQL Server Tools

3.1.1 To Open SQL Server Management Studio Notes

1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, and then
click SQL Server Management Studio.
2. In the Connect to Server dialog box, verify the default settings, and then click Connect. To
connect, the Server name box must contain the name of the computer where SQL Server is
installed. If the Database Engine is a named instance, the Server name box should also
contain the instance name in the format <computer_name>\<instance_name>.

3.1.2 Management Studio Components

Management Studio presents information in windows dedicated to specific types of information.
Database information is shown in Object Explorer and document windows.
Tool Purpose
Browse servers, create and locate objects, manage data sources, and view logs.
Using Object Explorer
This tool is accessed from the View menu.
Managing Registered Store connection information for frequently accessed servers. This tool is
Servers accessed from the View menu.
Store and organize scripts and related connection information in projects called
Using Solution SQL Server Scripts. You can store several SQL Server Scripts as Solutions and
Explorer use source control to manage scripts as they evolve over time. This tool is
accessed from the View menu.
Using SQL Server Create queries based on existing templates. You can also create your custom
Management Studio queries or alter the existing templates to fit your scenarios. This tool is accessed
Templates from the View menu.
Dynamic Help Show a list of related Help topics as you click on a component or type code.

The tools in SQL Server Management Studio work together. For example, you can:

Register a server with Object Explorer.
Open a SQL Editor window connected to a specific database from Object Explorer.
Object Explorer is a tree view of all the database objects in a server. This can include the
databases of the SQL Server Database Engine, Analysis Services, Reporting Services,
Integration Services, and SQL Server 2005 Compact Edition. Object Explorer includes
information for all servers to which it is connected. When you open Management Studio,
you are prompted to connect Object Explorer to the settings that were last used. You can
double-click any server in the Registered Servers component to connect to it, but you do
not have to register a server to connect.

The document window is the largest portion of Management Studio. The document
windows can contain query editors and browser windows. By default, the Object Explorer
Details page is displayed, connected to the instance of Database Engine on the current
computer.

Task List the various components of Management Studio.

LOVELY PROFESSIONAL UNIVERSITY 39