SQL Server Components

SQL Server provides a number of services and utilities that help you manage your data and your database more efficiently:

Client Network Utility Manages the client Net-Libraries and defines server alias names. Also use it to set the default options used by a database library. Most users won't need this utility; it's a tool for administrators.

Server Network Utility Similar to the Client Network Utility, but you work with server behaviors.

Enterprise Manager Provides a window into your server environment in which you can view the network structure, each database, and even each object within each database.

Data Transformation Services Import/Export Wizard An import/export wizard that has a lot of bells and whistles.

Profiler Runs efficiency reports on database components, which you can use to improve performance, reliability, and integrity.

Query Analyzer A graphical tool that helps you create and execute queries and other SQL scripts

Service Manager Checks the state of SQL Server.For the most part, all users need the Enterprise Manager and the Query Analyzer. That's where most of the work takes place. Beyond that, the tools you need depend on your level of involvement outside a particular database. Administrators will have a range of tools at their hands, and management will probably be interested in any number of analytical and management services available as add-ons.