polarsign

The tools and utilities available within SQL Server 2000 are presented; from the Client Network Manager to the Service Manager.

Introduction SQL Server 2000 provides many command-line and graphical tools and utilities that enhance the capabilities of the server and ease tuning and maintenance. Not all of these tools and utilities appear in Start menu, many of them don't have Start menu shortcuts.

In this article, I want to tell you about these tools and utilities. SQL Server 2000 Program Group You can see the most of the available tools in the SQL Server 2000 program group in your Start menu. Click Start, Programs, Microsoft SQL Server. SQL Server 2000 program group. This is the main group of tools and utilities you will work with when building database applications or when administering SQL Server 2000.

Books Online Books Online - is an online access to the SQL Server documentation set. Books Online provides all documented information about all aspects of SQL Server working. The Books Online is a compiled set of HTML pages, so you should use Internet Explorer 5.0 or later to view Books Online. Client Network Utility Client Network Utility - is an utility, which sets the default Net-Library and server connection information on clients, and displays the DB-Library options. Vienna Ensemble Pro Software. Configure SQL XML Support in IIS Configure SQL XML Support in IIS launches the IIS Virtual Directory Management for SQL Server to define and register a new virtual directory (virtual root), on the computer running Internet Information Services. IIS Virtual Directory Management for SQL Server instructs IIS to create an association between the new virtual directory and an instance of SQL Server 2000.

Enterprise Manager Enterprise Manager - is a main graphical utility, which allows you to perform system administration tasks using a graphical interface. This utility is used for configure servers, manage databases and database objects, schedule events, configure and manage replication, and so on. Import and Export Data Import and Export Data - is the Data Transformation Services (DTS) Wizard. It is used to import and export data and objects between heterogeneous OLE DB and ODBC data sources. Profiler Profiler - is the SQL Server Profiler utility enables you to monitor all activity on your SQL Server 2000. SQL Profiler can capture SQL Server 2000 events from a server and save these events in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. Query Analyzer Query Analyzer - is your primary interface for running Transact-SQL queries or stored procedures.

With this utility, you can analyze the plan of a query, view statistics information, and manage multiple queries in different windows simultaneously. Server Network Utility Server Network Utility - is an utility, which is used to specify the network protocol stacks on which the server will listen for client requests. This utility looks like the Client Configuration utility, but Client Configuration utility controls how your applications will connect to SQL Server, while Server Network is used to set which network libraries SQL Server 2000 is listening on. Service Manager Service Manager - is a tool, which is used to start, stop, and pause MSDTC, MSSQLServer and SQLServerAgent services. Service Manager can also be used to start, stop, and pause stop an instance of SQL Server 2000 Analysis Services. Other SQL Server 2000 Tools and Utilities These SQL Server 2000 command-line utilities is placed by installation into C: MSSQL BINN directory, by default. These utilities have not graphical user interface, and some of them are not documented in SQL Server Books Online.