first article in a series of two, discusses how to use the Microsoft SQL Server 2000 command line
utilities, and what are
they used for.
to be clear before I start, these
utilities are primarily used for diagnostic, configuration and data migration
purposes, rather than for database server administration.
find below all the 42 command line utilities available in an SQL Server
instance. Some of the tools described (for example bcp, distrib and osql)
have a complex syntax (huge set of options), therefore, a DBA needs permanent
access to Microsoft SQL Server 2000 e-documentation – Books Online, delivered
with your database server installation media.
Most of the utilities, discussed below, are installed into Program
FilesMicrosoft SQL Server80ToolsBinn, while the others are installed into
Program FilesMicrosoft SQL ServerMSSQLBinn and Program
FilesMicrosoft SQL Server80Com.
Be aware that ‘Program FilesMicrosoft SQL
Server80ToolsBinn’ directory is added to a system path, so utilities located
here can be run from a command prompt (without specifying a full path). As for
any other utilities (i.e. those not in the ‘Program FilesMicrosoft SQL
Server80ToolsBinn’ directory) should be run from the command prompt in the
directory in which the utility is installed or the path should be explicitly