Microsoft SQL Server 2000 command line utilities (Part 2)

This article is a continuation of “Microsoft
SQL Server 2000 command line utilities (Part 1)
,” which began our
discussion of how to use the
Microsoft SQL Server 2000 command line utilities, and what are they used for. .
Most of these utilities are primarily used for diagnostic, configuration and
data migration purposes, rather than for database server administration.

Profiler – Profiler is
the executable for SQL Server Profiler. SQL
Server Profiler is typically used for monitoring SQL Server events, such as debugging T-SQL statements and stored procedures and
troubleshooting problems (by capturing them in a real-time and replaying
later).

Profiler is installed to the Program FilesMicrosoft
SQLServer80ToolsBinn directory by default.

Qrdrsvc – Ordrsvc configures
and begins the Replication Queue Reader Agent, which reads messages stored in a
SQL Server queue or a Microsoft Message Queue and then applies those messages
to the Publisher. Queue Reader Agent is used with snapshot and transactional
publications that allow queued updating. The

Qrdrsvc utility is
installed to the Program FilesMicrosoft SQLServer80Com directory by
default.

Readpipe – Readpipe is
a diagnostic utility used for the network Named Pipe services
“checks-if-it-is-working” integrity testing. Readpipe is launched on the SQL-client
console, which cannot connect to SQL Server. Readpipe used in conjunction with Makepipe utility.

This utility is no longer installed by SQL Server 2000
Setup. If you need to run it – please do so manually, from the x86Binn
directory on the SQL Server 2000 compact disc, or manually copy it to any
location.

Rebuildm
– The Rebuildm utility is used for 1) fixing a corrupt master database,
and 2) changing the character set, sort order or Unicode collation for a
Microsoft SQL Server installation. As usually, make sure that you have a valid
backup(s) for all user databases. After rebuilding master, you need to
reload all your data (user databases) from a backup(s) you have.

The Rebuildm utility
is installed to the Program FilesMicrosoft SQLServer80ToolsBinn directory
by default.

Regxmlss – Regxmlss is
used to configure Internet Information Server
(IIS) as a part of Microsoft SQL Server XML support. This allows you to store
canned queries (including stored procedure calls) on your IIS server, which can
be executed with optional parameters from a URL or posted from an HTML form.

The Regxmlss utility
is installed to the one directory inside of Program Files Common
FilesMicrosoft Shared (cannot find this file it in my environment).

Replmerg – The Replication
Merge Agent utility that configures and starts a replication Merge Agent, which
applies initial snapshots held in the database tables of the Publisher to the
Subscribers. Replmerg also merges data changes made by the Publisher or
Subscribers after the initial snapshot is created.

The Replmerg utility
is installed to the Program FilesMicrosoft SQLServer80Com directory by
default.

Replupd – Replupd is part
of the SQL Server replication subsystem. It is used to transfer replication
parameters from previous (6.x) versions of SQL Server.

The Replupd utility is installed to the Program FilesMicrosoft SQL
ServerMSSQLBinn directory by default.

Scm – Scm is a utility
used to create, modify, start, stop or pause SQL Server and Microsoft Data
Engine (MSDE) services (running under Windows NT/2000 operating systems) and
SQL Server applications (running under Windows 9x) from a command prompt or a
batch file (similar to using net start and net stop commands).
Note, that the Scm utility can be used only with the services, installed
by SQL Server.

The Scm utility is installed
to the Program FilesMicrosoft SQLServer80ToolsBinn directory by default.

Snapshot – Snapshot
refers to the Replication Snapshot Agent utility, which configures and starts a
replication Snapshot Agent, which in turn prepares snapshot files of the
published tables and stored procedures, stores the files on the Distributor and
records the information about the synchronization status in the distribution
database.

The Snapshot utility
is installed to the Program FilesMicrosoft SQLServer80Com directory by
default.

Sqladhlp – Sqladhlp is a service that helps Microsoft SQL Server and Microsoft
SQL Server Analysis Services to publish information in Active Directory when
SQL Server Service and Analysis Server Service are not running under the Local
System account. This service is dynamically started by an instance of SQL
Server or Analysis Manager when needed. The service is stopped as soon as it
has completed its work. This service should always be run from the Local System
account and should not be started manually from console.

The Sqladhlp utility
is installed to the Program FilesMicrosoft SQLServer80ToolsBinn directory
by default.

Alexzander Nepomnjashiy
Alexzander Nepomnjashiy
I am a Microsoft SQL Server Database Designer for Neo-Systems North-West - a security services, consulting, and training company. I have over eight years of experience in the IT field. I am currently working on several projects which involve the deployment of Microsoft Windows NT Server/Microsoft SQL Server within an enterprise business/financial environment. My typical role in these projects includes extending and improving our clients' corporate ERP systems to manage retail sales data, predict market changes and calculate trends for future market situations (DSS, OLAP). Also among my responsibilities are the design and administration of Microsoft SQL Server 7.0/2000 databases. I am available to work on a contract basis for the following types of projects: - Technical authoring, including books, articles, and white papers; - Network and systems design and analysis; - Database and software development and analysis; - Short-term consulting projects. I hope you find these articles useful. If you have any ideas for future articles (in a field of Microsoft SQL Server databases design, administration, performance optimization), or if you have anything to say about the ones below, please do not hesitate to contact me! Feel free to forward these articles to all interested associates. Thank You!

Latest Articles