Microsoft SQL Server 2000 command line utilities (Part 2)
March 2, 2004
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 Files\Microsoft SQLServer\80\Tools\Binn 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 Files\Microsoft SQLServer\80\Com 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 \x86\Binn 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 Files\Microsoft SQLServer\80\Tools\Binn 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 Files\Microsoft 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 Files\Microsoft SQLServer\80\Com 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 Files\Microsoft SQL Server\MSSQL\Binn 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 Files\Microsoft SQLServer\80\Tools\Binn 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 Files\Microsoft SQLServer\80\Com 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 Files\Microsoft SQLServer\80\Tools\Binn directory by default.