Printed 2017/08/24 01:28AM

SQL Server 2005 Management Tools

By Dukagjin Maloku, 2008/07/10

SQL Server 2005 includes a set of graphical tools and most of these are new with SQL Server 2005, there si a brief information of them:

It is an integrated environment for accessing, configuring, administering and developing all components and objects of SQL Server. SSMS combines the feature of Enterprise Manager & Query Analyzer ( from SQL Server 2000) into a single environment.

Is an integrated development environment for Analysis Services, Reporting Services and Integration Services solutions that is based on Visual Studio. Visual Studio has templates that provides access for building business intelligence projects.

Provides basic configuration management for the SQL Server Windows services, server protocols, client protocols and client aliases.

Provides a graphical user interface for monitoring an instance of the Database Engine or an instance of Analysis Services.

Helps to create optimal sets of indexes, indexed views, and partitions to improve database performance!


Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.