Microsoft SQL Server 2000 command line utilities (Part 2)

Tuesday Mar 2nd 2004 by Alexzander Nepomnjashiy
Share:

Alexzander Nepomnjashiy continues his examination of how to use the Microsoft SQL Server 2000 command line utilities and what they are used for.

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.

Sqlagent - Sqlagent is used to start the SQL Server Agent service from the operating system command prompt. It should be run manually, from a command prompt, for diagnosing SQL Server Agent purposes only.

The Sqlagent utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Sqldumper - Sqldumper generates a "dump-on-demand" file for any Microsoft Windows application. For example, Microsoft PSS might ask you to run this program to generate a dump file (a mini-dump file or a full dump file) for debugging an application problem. Sqldumper was first introduced in Microsoft SQL Server 2000 Service Pack 3.

The Sqldumper utility is installed to the \Program Files\Microsoft SQLServer\80\Com directory by default.

Sqldiag - Sqldiag is a utility used for report generation and collection of diagnostic information on database server / operating system configuration parameters. Sqldiag gathers the information, even if Microsoft SQL Server 2000 services are stopped. The report generated by Sqldiag contains the following information:

  • Complete dump of all SQL Server error logs;
  • Registry information, related to SQL Server;
  • SQL Server system dll versions;
  • Output, generated by: sp_configure, sp_who, sp_lock, sp_helpdb, xp_msver and sp_helpextendedproc;
  • Information about all system processes (master..sysprocesses);
  • Information about all user processes and connections (including Input buffer SPIDs and Dead locks);
  • Information about operating system parameters (including reports about: OS version, Video display, Drivers, DMA, Memory, Services, IRQ and ports, Devices, Environment and Network);
  • Info about the last 100 user's queries.

The Sqldiag utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Sqlftwiz - Sqlftwiz is a command prompt utility that allows the Full-Text Indexing Wizard to be executed from a command prompt. The Full-Text Indexing Wizard is used to define full-text indexing on Microsoft SQL Server text-based columns.

The Sqlftwiz utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default.

Sqlmaint - Sqlmaint is a maintenance utility. Sqlmaint performs a set of tasks, specified by the DBA, on one or more databases (for example backup databases, update statistics, rebuild indexes, DBCC check).

The Sqlmaint utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Sqlmangr - Sqlmangr is the executable for SQL Server Service Manager. It is used to start, pause, stop, and check the state of local and remote SQL Server instances.

The Sqlmangr utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default.

Sqlservr - Sqlservr is used to start, stop, pause, and resume a Microsoft SQL Server instance from a command prompt. Most often, this utility is used to start SQL Server with a trace flag or temporarily override the default SQL Server startup options.

The Sqlservr utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Svrnetcn - Svrnetcn is the executable for SQL Server Network Utility. IT is used for configuring and permitting to use (enabling or disabling) a particular network protocol for an existing instance of SQL Server 2000 or MSDE 2000.

Svrnetcn is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

Textcopy - Textcopy is used for moving large arrays of text and binary data to (or from) text / image data type column(s) / row(s) and operating system files. This is an undocumented utility--(try to run it with /? switch - to receive a set of command line parameters that it accepts). An example of Textcopy usage can be found in Pubimage.bat and Pubtext.bat files, (both files are located in %sqlroot%\install folder).

The Textcopy utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Vswitch - Vswitch is used for switching between SQL Server 2000 and SQL Server 6.x (6.0, 6.5) default instances. The utility does not allow both versions of SQL Server to be run simultaneously, and it is only intended to be used during the migration phase, not in daily production.

The utility copies the current registry value to either the MSSQLSERV6.x or 2000 registry key and then moves the desired version information (6.x or 2000) to the MSSQLServer entry. Additionally, it changes the PATH statement to reflect the SQL Server root directory.

The Vswitch utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Wiztrace - Wiztrace is the executable for the Index Tuning Wizard workload generator. It is used internally by the Index Tuning Wizard.

The Wiztrace utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

Xpadsi - Xpadsi is the SQL Server Active Directory (AD) registration program. A search for additional info (SQL Server Books OnLine, Microsoft Technet, MSDN) did not yield any useful information. It seems that this utility does not require any command line parameters and is used internally by the SQL Server setup program.

The Xpadsi utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

This two-part article has introduced tools hidden in every SQL Server 2000 installation, with the primary focus being an introduction to the SQL Server command line utilities.

» See All Articles by Columnist Alexzander Nepomnjashiy

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved