Microsoft SQL Server 2000 is a full-featured relational database
management system (RDBMS) that offers a variety of administrative
tools to ease the burdens of database development, maintenance and
administration.
Enterprise Manager is the main administrative
console for SQL Server installations. It provides you with a
graphical "birds-eye" view of all of the SQL Server installations
on your network. You can perform high-level administrative
functions that affect one or more servers, schedule common
maintenance tasks or create and modify the structure of individual
databases.
Query Analyzer offers a quick and dirty method
for performing queries against any of your SQL Server databases.
It's a great way to quickly pull information out of a database in
response to a user request, test queries before implementing them
in other applications, create/modify stored procedures and execute
administrative tasks.
SQL Profiler provides a window into the inner
workings of your database. You can monitor many different event
types and observe database performance in real time. SQL Profiler
allows you to capture and replay system "traces" that log various
activities. It's a great tool for optimizing databases with
performance issues or troubleshooting particular problems.
Service Manager is used to control the
MSSQLServer (the main SQL Server process), MSDTC (Microsoft
Distributed Transaction Coordinator) and SQLServerAgent processes.
An icon for this service normally resides in the system tray of
machines running SQL Server. You can use Service Manager to start,
stop or pause any one of these services.
Data Transformation Services (DTS) provide an
extremely flexible method for importing and exporting data between
a Microsoft SQL Server installation and a large variety of other
formats. The most commonly used DTS application is the "Import and
Export Data" wizard found in the SQL Server program group.