SQL Server 2000 components
Terms
undefined, object
copy deck
- Microsoft SQL Server 2000 Analysis Services service
-
MSSQLServerOLAPService implements SQL Server 2000 Analysis Services.
There is only one service, regardless of how many instances of SQL Server - Microsoft Search service
-
implements the full-text search engine.
There is only one service, regardless of the number of instances of SQL Server 2000. - Microsoft Distributed Transaction Coordinator (MS DTC) service
-
manages distributed transactions between instances of SQL Server 2000.
There is only one service, regardless of the number of instances of SQL Server 2000. - SQL Server service
-
implements the SQL Server 2000 database engine.
one service for each instance of SQL Server 2000. - SQL Profiler
- Used to monitor and capture selected SQL Server 2000 events for analysis and replay. Supports C2 security-level auditing.
- SQL Query Analyzer
- Used for creating and managing database objects and testing Transact-SQL statements, batches, and scripts interactively.
- SQL Server Service Manager
- A taskbar application used to start, stop, pause, or modify SQL Server 2000 services.
-
Graphical Tool
SQL Server Enterprise Manager - The primary server and database administration tool, it provides a Microsoft Management Console (MMC) snap-in user interface.
- Client Network Utility
- Used to manage the client Net-Libraries and define server aliases containing custom server connection parameters, if needed.
- AppleTalk ADSP
- Used in the Macintosh and Apple network environment. ADSP enables Apple Macintosh clients to connect to SQL Server 2000 using native AppleTalk.
- Service Control Manager - SCM
- used to start, stop, pause, install, delete or modify SQL Server 2000 services. It also can start, stop, or pause SQL Server running as an application.
- Sqldiag
- gathers and stores diagnostic information to expedite and simplify information gathering by Microsoft Product Support Services
- OSQL
-
allows you to query an instance of SQL Server 2000 interactively using Transact-SQL statements, system procedures, and script files.
Replaces Isql - Shared memory
- Used to connect to SQL Server 2000 on the same computer using a segment of memory. This is one of the default protocols for SQL Server 2000.
- DTS run
- executes packages created using DTS.
- BCP
- utility copies data between an instance of SQL Server 2000 and a data file in a user-specified format.
- VIA GigaNet SAN
- Used to support the new, high-speed SAN technology on GigaNet's cLAN server farm network.
- Multiprotocol
- Supports any available communication method between servers using Windows NT RPCs over any available network protocol.
- SQLMAINT
- performs a specified set of maintenance operations on one or more databases. includes performing DBCC consistency checks, backing up data and transaction log files, updating distribution statistics, and rebuilding indexes.
- SQL Server Agent service
-
implements the agent that runs scheduled SQL Server 2000 administrative tasks.
There is one service for each instance of SQL Server 2000. - NWLink IPX/SPX
- Used in the Novell network environment, primarily legacy Novell environments that do not support TCP/IP.
- Named pipes
- Used to connect to SQL Server 2000 using named pipes. A pipe is a file-system mechanism used for communication between processes. This is one of the default protocols for SQL Server 2000.
- TCP/IP Sockets
- Used to connect to SQL Server 2000 using TCP/IP. This is one of the default protocols for SQL Server 2000.