Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
23 Cards in this Set
- Front
- Back
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.
|