Transcript SQL Server Management Studio

SQL Server Management
Studio Introduction
2914
What Is It
• SQL Server Management Studio is an integrated environment for
accessing, configuring, managing, administering, and developing all
components of SQL Server.
• SQL Server Management Studio combines a broad group of
graphical tools with a number of rich script editors to provide access
to SQL Server to developers and administrators.
• SQL Server Management Studio combines the features of
Enterprise Manager, Query Analyzer, and Analysis Manager,
included in previous releases of SQL Server, into a single
environment.
• In addition, SQL Server Management Studio works with all
components of SQL Server such as Reporting Services.
Tool Windows in SQL Server
Management Studio
•
•
•
•
•
•
Tools
Using Object Explorer Browse servers, create and locate objects, manage
data sources, and view logs. This tool is accessed from the View menu.
Managing Registered Servers Store connection information for frequently
accessed servers. This tool is accessed from the View menu.
Using Solution Explorer Store and organize scripts and related connection
information in projects called SQL Server Scripts. You can store several
SQL Server Scripts as Solutions and use source control to manage scripts
as they evolve over time. This tool is accessed from the View menu.
Using SQL Server Management Studio Templates Create queries based on
existing templates. You can also create your custom queries or alter the
existing templates to fit your scenarios. This tool is accessed from the View
menu
.Dynamic Help Show a list of related Help topics as you click on a
component or type code.
Administering Servers with SQL
Server Management Studio
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Use Management Studio to:
Register servers.
Connect to an instance of the Database Engine
Configure server properties.
Manage database and SSAS objects such as cubes, dimensions, and assemblies.
Create objects, such as databases, tables, cubes, database users, and logins.
Manage files and file groups.
Attach or detach databases.
Launch scripting tools.
Manage security.
View system logs.
Monitor current activity.
Configure replication.
Manage full-text indexes.
•
Work citied http://msdn.microsoft.com/en-us/library/ms174173.aspx