Database Reference
In-Depth Information
18.4.2 Management Tools
The management tools are enabled by default; they consist of the following:
•
Enterprise Manager is the graphical management interface for
both development and administration of SQL Server.
•
The SQL Server Profiler is a great tool for monitoring SQL Server
activities, including queries and how these queries are run. It also
provides performance measurements.
•
Query Analyzer is the component used to enter and run
Transact-SQL statements. One can also view how SQL Server will
optimize and run queries. Experienced T-SQL developers tend to
use this tool.
•
DTC Client Support allows you to use the Distributed
Transaction Coordinator to run data modification queries across
multiple systems.
•
Conflict Viewer is the conflict resolution wizard for merge replication.
18.4.3 Client Connectivity
Client Connectivity is a set of components that facilitates communication with the
SQL Server. This set includes components for Open Database Connectivity (ODBC),
Object Linking and Embedding Database (OLE DB), and DB-Library. Each library allows
you to write or use programs that connect to SQL Server. Collectively, they are known as
the MDAC (Microsoft Data Access Components).
18.4.4 Development Tools
The main development tools are described below:
•
Headers and Libraries are the C++ files needed for development
of SQL Server programs.
•
MDAC system development kits (SDKs) are the Software
Development Kits for XML and the Microsoft Data Access
Components. These SDKs allow enable and support the
development of programs using XML and MDAC.
•
Backup/Restore API includes a sample program, necessary
C/C++ files, and documentation on how to build backup and
restore programs.
•
Debugger Interface installs the components necessary to allow
Microsoft Visual Studio components and the SQL Server Query
Analyzer utility the capability to debug stored procedures.
This option is selected by default.
