Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/23

Click to flip

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.