MS SQL Basics Tutorial: Tools for SQL Server 2000

Source: Internet
Author: User
Tags iis

1.3.4 Profiler

SQL Server Profiler is a graphical management tool for monitoring the use of SQL Server databases for system administrators It is a spy that monitors user activity

1.3.5 Client Network Utility

SQL Server Client Network Utility used to configure the connection of the client to determine version information for the network library and to set options for the local database

1.3.6 Server Network Utility

SQL Server server network Utility used to configure server-side connectivity to determine version information for a network library

1.3.7 Import and Export Data

Import and export data imports and exports using the DTS Import/export Wizard to complete this wizard contains all of the DTS Data Transformation Services Data Transformation Service tools that provide replication between OLE DB data sources The simplest method of data

1.3.8 SQL Server Upgrade Wizard

The SQL Server Upgrade Wizard is used to upgrade the settings and database replication of a 6.5 version of SQL Server to SQL Server 2000 installed on this computer

1.3.9 Configure SQL XML Support in IIS

IIS is an abbreviation for Internet Information Services The Internet Information Service This tool enables you to define registered virtual directories and create associations between virtual directories and SQL Server instances on the computer running IIS

1.3.10 DTC Client Support

DTC distribute Transaction Coordinator distributed Transaction Coordinator for providing and managing distributed transactions between different servers these servers must be servers based on Windows NT or Windows 9x/2000 series operating systems

1.3.11 Replication Conflict Viewer

Replication Conflict Viewer is a replication conflict observer that can be used to change the way conflicts are resolved by checking the database for replication conflicts

1.3.12 Books Online

SQL Server 2000 provides a large number of online documents users can easily query many valuable information a good SQL Server administrator must be the master of using online documentation

This chapter provides a brief introduction to SQL Server 2000 's new feature-related tools, and the use of the tools for SQL Server will be described step-by-step in later chapters.

View a complete set of "MS SQL Primer Tutorials" >>>>>

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.