MS SQL Basics Tutorial: Tools for SQL Server 2000

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" >>>>>