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
» 
Comment and Contribute
